Excel/IT help


#1

Hello

My work computer for some reason isn’t displaying Excel very well. All the numbers look funny like this.

image

Is there a setting to change, before I email around the team and look like a doofus (I’m supposed to be an Excel whizz)


#2

Please explain what you mean by ‘they look funny’
Ta


#3

I’m sure you’ve done this but my first port of call is clear all formatting

(I pretend that I can use excel for my job but can’t use it so please can we turn this thread into a general excel thread)


#4

yep tried that


#5

random numbers seem to be in bold or partly in bold. should be visible in the screengrab


#6

Thought that was what you meant but just wanted to check


#7

Edit I look foolish


#8

I’ve had this before and highlighted / clicked bold / unclicked bold. Also (bizarrely) changed the column width to correct it.
Otherwise, I’m out


#9

yes sorry as clarified above the issue isn’t the actual numbers it’s the way the font is rendering on excel with a strange bold effect on some of the numbers


#10

doesn’t fix it unfortunately. thanks though.

It doesn’t seem to be a formatting issue, but more something either in excel’s settings or a computer display setting that Excel doesn’t like


#11

idk is it a complicated sheet? can you upload it to another workbook e.g. google sheets and see if the problem is still there?


#12

Are the figs from a pivot?


#13

Mine does this sometimes. It’s a problem with how Windows is displaying stuff rather than Excel itself. Closing Excel, then rebooting the computer always fixes it.


#14

Dunno if it’s tge same thing but excel will go visually weird when low on memory, like it won’t show the result of a formula but the formula itself and then resizing a column will stretch and distort it like it’s a picture


#15

I’ve tested it with other sheets and the formatting issue seems to be on Calibri 11. If you size up or down it goes away and arial renders ok as well.


#16

I’ll give a reboot a try and see if there are any updates that I need to install. thanks everyone for your help so far


#17

How much do you love Calibri 11…?


#18

Has it been zoomed in/out to a size that means it can’t decide if the numbers should be 1px wide or 2?


#19

ahh fixed it. had to turn on and tune Cleartype settings in Windows.

Thanks everyone for your help!


#20

Hi. This is probably really simple - I have a spreadsheet with different tabs called January, February and so on. I have a summary tab with the months as column headers. I want a formula to return a specific result from each tab - for example, if I want column X rows 2-12 from the January tab to go into rows 2-12 in the January column from my summary tab, is there a formula that I can easily copy all over my summary tab?

I’d be wanting the same results from each one (e.g. row X column 1-12 from each month)