- #EXCEL KEYBOARD SHORTCUTS PRINTABLE LIST HOW TO#
- #EXCEL KEYBOARD SHORTCUTS PRINTABLE LIST PRO#
- #EXCEL KEYBOARD SHORTCUTS PRINTABLE LIST FREE#
The General number format is probably the number type you will use most often. You can do this as many times as needed and it will save you a lot of time especially when formatting cells that are not located close together. To repeat your last formatting action into a next cell, press F4 on the new cell to be formatted. The apostrophe will not print or display in the cell, but will ensure Excel does not try to autoformat the cell. To ensure Excel treats such types of content as text, insert an ‘ (apostrophe) in front of the number. This can be annoying when you are trying to enter specific types of data, for example, a telephone number or an item number that displays incorrectly. Often times when a formula is yielding unexpected results, the problem is not with the formula but with the underlying number format(s).Įxcel often tries to think for you and will identify the content entered into a cell and assign a format to it automatically.
For example, if you study the screenshot of a section of a worksheet below, you will note the data types are text, date, time, currency and possibly percentage.įormatting numbers and other data types in a worksheet not only adds context making it easier to read and understand the data, it also allows you to perform formula calculations. Select the most appropriate format for your selected data type from the list.ĥ. Press Ctrl+1 on your keyboard to launch the Number Format dialogue box (see screenshot below):Ĥ. Select the affected cells, columns or rows.ģ. To apply number formats, decide what type of data the cells, column or rows will contain.Ģ. It is important to decide the types of data you are expecting a column, row or section of cells to contain and then format those cells accordingly, preferably before the data has even been inserted.ġ. This makes complex calculations, for example, subtracting times and dates and scientific calculations, possible.
#EXCEL KEYBOARD SHORTCUTS PRINTABLE LIST HOW TO#
The type of number format you apply to a cell adds value to the cell in that it tells a formula or function what type of data to expect and how to handle that data. There is a lot more to number formats in Excel than just making your worksheet look neat and professional.
#EXCEL KEYBOARD SHORTCUTS PRINTABLE LIST FREE#
Test your Excel skills with the corresponding FREE Online Multiple ChoiceĮxcel Keyboard Shortcuts for Formatting Numbers Test
#EXCEL KEYBOARD SHORTCUTS PRINTABLE LIST PRO#
Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to format numbers. * Shortcuts for General Number & Scientific Number Formats Excel Tutorial – Keyboard Shortcuts for Formatting Numbers Tutorial with corresponding Free Online Test – Excel 2010 Keyboard Shortcuts for Formatting Numbers Free Online Microsoft Excel Tutorial
0 kommentar(er)
