Mar 25, 2014 Search. Site Feedback. ChangeAgent Created on February 17, 2012. Ignore blank cell when looking for the minimum value I use: =MIN(D40:AX40) Of course if a cell is blank or contains a zero the minimum becomes zero. How to have the formula ignore blank cells or cells with zero? Excel / Mac / Office 2011 for Mac.
Learning the shortcuts on any program can cut the time it takes to produce a document. With a program like Excel that has so many uses, knowing some of its shortcuts can make navigating, entering, and setting up worksheets quicker to do. Reasons to Use Shortcuts Excel has many uses, although creating spreadsheets is probably its most common one. Within a spreadsheet, both written and numerical data is often used, so learning some of the shortcuts for both types of data can help save time when trying to organize information. Image via Using shortcuts takes less time because you won’t need to use the mouse to go to the ribbon to find the function or formula that you need. Also, by memorizing the shortcuts, your work will be more precise. You will be less likely to make mistakes that will need to be corrected by yourself or someone else.
Creating spreadsheets can be a tedious job, especially if there are large amounts of data to organize. However, by learning Excel shortcuts, the task can become easier because it will be quicker to do, and your accuracy will improve as well. Here are 20 Excel shortcuts for Windows and Mac that can help you work more efficiently.
Workbook Operations When you’re ready to start a new worksheet or continue working on one, these shortcuts can help open a current workbook or a new one and save it when you’re done finished entering information on it. Open Workbook: Ctrl + O (Windows and Mac) This shortcut helps you open a workbook on which you’ve been working. Once you press the keys, the recent workbooks box will appear, and you can choose the one you need. New Workbook: Ctrl + N (Windows and Mac) If you need to open a new workbook, this shortcut works for both the Windows and Mac operating systems. New Worksheet: Shift + F11 (Windows and Mac) This shortcut adds a new worksheet to a workbook. Save As: F12 (Windows) ⌘+ Shift + S (Mac) The F12 function key helps you save the worksheet or workbook on Windows. The combination of the keys shown above will do that on a Mac computer.
After the keys are pressed, the dialog box opens so you can insert the name of the workbook. Close Excel: ALT + F4 (Windows) Ctrl + Q (Mac) When you’re finished with Excel, this shortcut closes the program, not just the workbook.
Ribbon Operations If you’re new to Excel, you may not be familiar with the ribbon. The ribbon is the box above the worksheet that displays the tabs and buttons for the various commands on the application. Vestax spin dj usb controller for mac. Show or Hide Ribbon: Ctrl + F1 (Windows) ⌘ + OPT + R (Mac) Use this shortcut to open or hide the ribbon box. Show Ribbon Accelerator Keys: Alt (Windows) n/a (Mac) The accelerator keys are other shortcuts on Excel.
When you select Alt on a Windows computer, a letter or number appears under the tabs on the ribbon. These include the: • File • Home • Insert • Page Layout • Formulas • Data • Review • View • Help • Save Icon When you press the letter or number under the tab, letters or numbers will appear under the commands for that task. You can then use shortcuts to do whatever you need.
For example, when you press Alt and W under the View tab, a Q appears under Zoom. Then, selecting Q allows you to enlarge the information on the worksheet. Editing Operations After you use some of the shortcuts, you may want to make corrections by undoing something, or you may want to copy data to paste it into another row or cell. These shortcuts are self-explanatory. Copy: Ctrl + C (Windows and Mac) Paste: Ctrl + V (Windows and Mac) Undo: Ctrl + Z (Windows and Mac) Cut: Ctrl + X (Windows and Mac) Spellcheck: F7 (Windows and Mac) Formatting Operations Some functions will be used more than others, so the most common ones are listed here. These shortcuts don’t need any further explanation either.