Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

question everything

(47,476 posts)
Sat Apr 16, 2016, 02:49 PM Apr 2016

Anyone using Microsoft Excel?

Mine is for the Mac 2011.

Once a week, or so, I visit many of our retirement funds and savings and copy and paste the values from the web page into an excel cell. I use Veranda size 9, but it can be any font and size.

It works fine with Safari, but with Firefox - even with earlier versions - it would paste at Calibri (body) size 12. It does not matter that I format the whole page, or the column, the result is always the same. Calibri (body) 12.

Any idea what is so special about this font when I am copying and pasting a value from a web page?

Hope it is not too confusing.

Thanks

4 replies = new reply since forum marked as read
Highlight: NoneDon't highlight anything 5 newestHighlight 5 most recent replies
Anyone using Microsoft Excel? (Original Post) question everything Apr 2016 OP
Sounds like it's a Firefox thing NV Whino Apr 2016 #1
Paste values bcool Apr 2016 #2
Or hover over Match Destination or Keep Source Formatting CurtEastPoint Apr 2016 #3
Thanks! That did it question everything Apr 2016 #4

NV Whino

(20,886 posts)
1. Sounds like it's a Firefox thing
Sat Apr 16, 2016, 02:56 PM
Apr 2016

Very frustrating.

You might check your FF preferences to see if there is anything weird checked.

bcool

(219 posts)
2. Paste values
Sat Apr 16, 2016, 03:12 PM
Apr 2016

Do you right-click in the destination cell and select 'Paste Special', then 'Values'? That way, it won't include the formatting from the source web page.

CurtEastPoint

(18,641 posts)
3. Or hover over Match Destination or Keep Source Formatting
Sat Apr 16, 2016, 03:28 PM
Apr 2016

and pick whichever's best.

If all else fails click the square above row 1 and left of column a to select all cells and change the font.

question everything

(47,476 posts)
4. Thanks! That did it
Sat Apr 16, 2016, 04:28 PM
Apr 2016

At least, the right click and paste special. Did not see values, but selected the Unicode text. Amazing.




One of the best features of DU..
Thanks, again.

Latest Discussions»Culture Forums»Apple Users»Anyone using Microsoft Ex...