- #EXCEL COPY FORMATTING SHORTCUT HOW TO#
- #EXCEL COPY FORMATTING SHORTCUT FREE#
- #EXCEL COPY FORMATTING SHORTCUT WINDOWS#
As long as you remember that each number between 1 and 6 represents a different number format, you can rely on the symbols on your keyboard to indicate which number corresponds to each number format.Ĭurrency ($) and Percentage (%) formatting are the easiest to remember – the dollar and percentage symbols are right there! Fortunately, they’re two of the more common number formats which are used in Excel.Ĭhanging number formats into Date and Time are a little less easy to memorise. Ctrl + Shift + 6 (^): Applies Exponential formatting (eg: 123+E02).Īs you can see, the shortcut keys are grouped together using Ctrl, Shift and a number.
Try Alt-H-0 to increase the number of decimal places, or Alt-H-9 to decrease them. Ctrl + Shift + 5 (%): Applies Percentage formatting with no decimal places (eg: 12%).Ctrl + Shift + 4 ($): Applies Currency formatting (based on your default currency) (eg: $12,345.00).Ctrl + Shift + 3 (#): Applies Date formatting (based on your default date options) (eg: ).Ctrl + Shift + 2 Time formatting (eg: 3:45PM).Ctrl + Shift + 1 (!): Applies Number formatting with two decimal places (eg: 12,345.00).We can do better than this!įortunately, the shortcuts for the more common types are very easy to remember – and I’ll give you some easy tips to easily memorise them in just a minute. Normally you can select the number format from this dropdown menu, located in the Excel Ribbon in the “Home” tab.īut this can be extremely tedious, especially if you have to format your data in a wide range of number types. It’s important to remember that the number formatting of a cell doesn’t change the data you’ve entered – format changes are easy to reverse. You can choose to present a value as a number, as currency, as a percentage, in a date or time format, and there are several other types which are less common.
#EXCEL COPY FORMATTING SHORTCUT FREE#
Click here to get the free eBook now! Format cells as currency, number, date/time etcĪs most Excel users will know, the data in every cell in a Microsoft Excel file can take on many different types. Getting to the Format Cells dialog box is just one of the tips in the FREE eBook “10 Simple Microsoft Excel Tips to Save You Time”. If you have multiple cells selected, any formatting changes you make from using this shortcut will apply to all of those cells.
Whenever someone wants to change some of the more complicated formatting in Excel, the majority of people will right click on the cell they want to change, and choose “Format Cells”.Ĭtrl + 1 is the shortcut to instantly open up the Format Cells dialog box. If you only choose to use one new shortcut from this post, it has to be this one. Must-learn: Go to the “Format Cells” dialog box
#EXCEL COPY FORMATTING SHORTCUT WINDOWS#
Most Excel users will know these shortcuts as they are consistent across all Windows applications. Ctrl + U: Applies Underlined formatting to the selected cell(s).Ctrl + I: Applies Italic formatting to the selected cell(s).Ctrl + B: Applies Bold formatting to the selected cell(s).Let’s get the obvious ones out of the way – these three shortcuts are extremely common and well-known. Keep it consistent: Using the Paste Formats shortcut.Format cells as currency, number, date/time etc.Must-learn: Go to the “Format Cells” dialog box.