10 Excel Dialog Box Definitions:
1. Arrange All
The Arrange All dialog box is used to stack all open workbook windows so they can all be viewed simultaneously. To open the Arrange All box, navigate to the View tab, select Arrange All, or press ALT W A.
The Arrange All dialog box is used to stack all open workbook windows so they can all be viewed simultaneously. To open the Arrange All box, navigate to the View tab, select Arrange All, or press ALT W A.
2. Excel Options
The Excel Options dialog box is used to personalize the system settings of Excel. To open the Excel Options box, go to the File tab, select Options, or hit ALT F T.
The Excel Options dialog box is used to personalize the system settings of Excel. To open the Excel Options box, go to the File tab, select Options, or hit ALT F T.
3. Macros
The Marco dialog box is used to create new macros or run, edit, and delete existing macros. To open the Macro box, go to the developer tab, select Macros, or hit ALT F8.
The Marco dialog box is used to create new macros or run, edit, and delete existing macros. To open the Macro box, go to the developer tab, select Macros, or hit ALT F8.
4. Paste Special
The Paste Special dialog box is used to select a paste option for copied cells. To open the Paste Special box, go to the Home tab > Paste dropdown > paste special or press CTRL ALT V.
The Paste Special dialog box is used to select a paste option for copied cells. To open the Paste Special box, go to the Home tab > Paste dropdown > paste special or press CTRL ALT V.
5. Format Cells
The Format Cells dialog box is used to select the desired format to apply to the selected cells. To open the Format Cells box, go to the Home tab, open Format dropdown, select Format Cells or press CTRL 1.
The Format Cells dialog box is used to select the desired format to apply to the selected cells. To open the Format Cells box, go to the Home tab, open Format dropdown, select Format Cells or press CTRL 1.
6. Insert Function
The Insert Function dialog box searches for what function you should use based on what you need to calculate and provides function definitions. To open the Insert Function box, go to the Formulas tab, select Insert Function, or press SHIFT F3.
The Insert Function dialog box searches for what function you should use based on what you need to calculate and provides function definitions. To open the Insert Function box, go to the Formulas tab, select Insert Function, or press SHIFT F3.
7. Cell Style
The Cell Style dialog box is used to select a style to apply to the selected cells. To open the Cell Style box, go to the Home tab, open the Cell Style dropdown, select New Cell Style, or press ALT ‘.
The Cell Style dialog box is used to select a style to apply to the selected cells. To open the Cell Style box, go to the Home tab, open the Cell Style dropdown, select New Cell Style, or press ALT ‘.
8. Move or Copy
The Move or Copy dialog box is used to move or copy the active worksheet into a newly specified location. To open the Move or Copy box, right-click the active worksheet, select Move or Copy, or press ALT H O M.
The Move or Copy dialog box is used to move or copy the active worksheet into a newly specified location. To open the Move or Copy box, right-click the active worksheet, select Move or Copy, or press ALT H O M.
9. Name Manager
The Name Manager dialog box is used to create new named ranges and edit/delete existing named ranges. To open the Name Manager box, go to the Formulas tab, select Name Manager, or press CTRL F3.
The Name Manager dialog box is used to create new named ranges and edit/delete existing named ranges. To open the Name Manager box, go to the Formulas tab, select Name Manager, or press CTRL F3.
10. Go To
The Go To dialog box is used to jump to a named range or any cell reference. The 'Special' button selects cells that meet criteria, such as blank cells, cells containing errors, etc. To open the Go To box, go to the Home tab > Find & Select > Go To, or press CTRL G.
The Go To dialog box is used to jump to a named range or any cell reference. The 'Special' button selects cells that meet criteria, such as blank cells, cells containing errors, etc. To open the Go To box, go to the Home tab > Find & Select > Go To, or press CTRL G.
Who knew all 10?!
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com
Loading suggestions...