You can even double click the paintbrush after selecting a source, and then paint many times on all different cells to spread the joy. Font, font size, font color, background color, borders, you name it, you can paint it. You simply select the source cell, tap the little paintbrush in the Excel ribbon, and then tap on the destination cell and boom, all of your formatting has been copied and pasted. The problem it solves is when you have one cell (or a range of cells) formatted just the way you want them, but you have another cell (or another range of cells) that you want formatted just like the first. This is a fantastic little tool and I’ve used it for at least a decade. Item 28 was that the format painter wasn’t working in Excel. You may remember item 28 of the 36 tech things that went wrong in a single day for me, but for those who didn’t memorize the list, I’ll refresh your memory. But first, there has to be a reason for me to contact Microsoft. This is a story of awesome support from Microsoft. This week I was recording fan rotation in RPM, clock speed in GHz and temperature in degrees Fahrenheit and I wanted to do custom formatting so the numbers recorded would remain numbers, but of course Excel for iPad couldn’t do it.Īnd have I mentioned how much I hate OneDrive? So I tried to save a file from Excel on iPad to Excel in iCloud Drive so I could fix the formatting using my Mac, but it moved the file and somehow it doesn’t sync back to Excel on iPad.īut none of that is the subject of this article. Even simple things like changing the format of numbers is extremely limited. I was excited to get Excel on my iPad, but it’s soooo limited I pretty much hate using it.
Powerpoint for mac 2011 format painter how to#
When I first started begrudgingly using Office 365, I hated the animations when you move cells and such but I figured out how to turn them off and I was a bit happier. I don’t think it happens on my newer Mac, which is inexplicable since they were both clean installs. On my previous Mac, every single time I opened a spreadsheet (even an empty one), after 2 or 3 minutes I would get a spinning pizza wheel for 10 seconds. You know I’ve been a big fan of Excel for ages, but I often disparage Office 365’s version of Excel.
0 kommentar(er)
