So, the T over here is underlined, on the PC at least, and it gives you an indication. And so what you need to do here is copy with COMMAND + C, choose the cell you want and CTRL + COMMAND + V to get the Paste Special, and this time you’ll hit the fn + T for format.īasically, you can’t use F because that’s for formulas. On the Mac, it’s very much the same thing, the shortcut is a tiny bit different. So, the key is to copy first, then choose where you want to apply it to, CTRL + ALT + V for Paste Special, and ALT + T to jump to that spot on the window. So, ALT + T for formats, and notice that you can just hit ENTER and apply this formatting to this spot right here, hit ESC to get out of it. You can move up and down with the arrows, or better yet, you can actually jump to the specific option you want by going to whatever’s underlined.
So, the only way this works is, first, you’re going to actually take the cell that has the formatting that you want, select it, copy it with CTRL + C on the PC and COMMAND + C on the Mac, and then choose the cell that has…essentially where you want to apply it to, and then you’re going to do a CTRL + ALT + V on the PC, right? You’re doing a regular paste with CTRL + V, but a Paste Special by adding the ALT key in there, which brings you to this Paste Special window.
#Mac shortcut for excel to reduce digits how to
The beauty of this shortcut is that you learn how to copy and paste the formatting only, and the key to this is with Paste Special. So, the formulas, the formatting, the other properties behind the scenes that you may not have even seen. You may not know this, but when you’ve been copying and pasting for all these years, you’re pasting everything that came with it.
#Mac shortcut for excel to reduce digits full
Instead, you can copy and paste formatting only, using the shortcut in this video.ĭownload FREE Hands-On Exercises Full Video Transcript:Ĭopying and pasting formatting is one of the most time-saving shortcuts you will ever learn, because it lets you take your previous work and apply it anywhere you want in a snap. If you are still re-formatting your spreadsheets from scratch every time, you are throwing away hours of your life needlessly.
0 kommentar(er)
