Category: Excel®

Many of today’s desktop applications are designed to show the final formatting on the screen as you work on the product.  For example, in Microsoft® Word, as long as you view the document in “Print Layout” as you are typing, you will generally see on the screen what you can…

Jump to: Formatting Shortcuts | Navigation and Display Shortcuts | Formulas and Functions Shortcuts Selection and Editing [keyboard_shortcut title="Adds other nonadjacent cells or ranges to the selection" keys="Shift,F8"] [keyboard_shortcut title="Adds to the selection (toggle)" keys="Shift,F8"] [keyboard_shortcut title="Cancels the editing" keys="Esc"] [keyboard_shortcut title="Deletes all characters from the cursor to the end…

Applies to Excel 2010-2016 Adjusting how rows and columns of data are displayed can quickly become a nuisance. Every extra click you perform to make your spreadsheet readable is time spent away from more important tasks. Here are four tips for making common spreadsheet tasks simpler and faster: Add More…

Worksheets can be linked so that information shared between the two is always identical. This reduces errors and ensures consistency as information only needs to be entered in one place to be available in multiple locations. In our example today, data is gathered and duplicated between employees and departments. One…

Have you ever inherited a worksheet that someone else set up or you created and haven’t played in for some time? If you need to update the formulas and functions, but do not know what other calculations will be affected you could quickly make a lot of work for yourself!…

Subtotals are dynamic in that they adjust instantly based on filters. They are very useful when reviewing a table, as you can make small adjustments to see different perspectives on the information. Create a Subtotal Determine which column you want to subtotal. Sort the selected column (Column A in this…

Excel allows you to set certain cells to accept only a certain data format that you specify. You can prompt the user with guidelines about the proper way to enter their data. You can even specify that data must fall in a certain data range if you wish. When data…

Want a quick way to view and interpret data directly in the tables without resorting to graphs or charts? You can add color bars, icons or graphics that reflect the meaning of the data in each cell to get an “at a glance” view of your data. Conditional formatting means…

After your sparklines have been created, Excel offers several tools for you to control which value points are shown, set options on the vertical axis, and define how empty values are displayed. You can also change colors, apply styles from Office’s pre-loaded style gallery or apply a custom style that…

A sparkline is a tiny chart in the background of a cell. When you use a sparkline, you can easily see the relationships between it and its underlying data. And, you can copy sparklines to adjacent cells by using the Fill Handle. Sparklines are printed as-is when you print a…