![]() ![]() ![]() Note: You might need to press Fn+ Shift+ F8 if you are using a Mac or Windows laptop keyboard. You can press the Escape key to turn the Add or Remove Selection mode off, or press Ctrl+F8 again. You can also use the arrow keys and Shift on the keyboard to add to the selection. The advantage is that you can perform the selections with one hand. This is similar to holding the Ctrl key while selecting cells or ranges with the mouse. Just click each cell or range that you want to add to the selection. It allows you to select multiple cells and ranges that are not adjacent. Pressing Shift+ F8 will toggle Add or Remove Selection mode on. ![]() Rich discovered a new shortcut that will help him select multiple areas (cells or ranges). It also allows you to compare formulas between cells to see if there are any discrepancies. When you turn Show Formulas off, the columns will change back to their original size.Īs Nick mentioned, the Show Formulas view allows you to quickly see which cells contain formulas. The widths of the columns don't actually change, but the view makes them appear twice as wide. One thing you'll notice about this mode is that the column widths typically get wider to fit the formulas. This is the same as if you are editing the formula. Selecting a cell will also display the colored bounding boxes around cells & ranges that are referenced in the formula. With Show Formulas on, you will see the formulas in ALL of the cells on the worksheet, instead of the results of the formulas (values). You can also get to this view from the Formulas tab > Show Formulas button in the Ribbon. When you press Ctrl+~ (tilde or back quote), the Show Formulas mode is toggled on. I think Nick did a great job of explaining this shortcut, and why it's useful. Here are three that might help save some time with your everyday tasks. We received a lot of great comments from the Excel Campus community about their favorite or newly found shortcuts. The page was also recently updated with a Table of Contents in the sidebar to make it easier to navigate. You can also download a PDF version of the list on that page. So feel free to share this page with your co-workers and friends. ![]() Everyone loves to learn new Excel shortcuts. We recently published a new page that contains a list of over 270 Excel shortcuts for the Windows, Mac, and Web versions of Excel. Watch on YouTube & Subscribe to our Channel Excel Shortcuts List Updated ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |