Search results
Results from the WOW.Com Content Network
Insert a worksheet. Select the New Sheet plus icon at the bottom of the workbook. Or, select Home > Insert > Insert Sheet. Rename a worksheet. Double-click the sheet name on the Sheet tab to quickly rename it. Or, right-click on the Sheet tab, click Rename, and type a new name. Move a worksheet.
Add a custom tab. When you click New Tab, you add a custom tab and custom group. You can only add commands to custom groups. In the Customize the Ribbon window under the Customize the Ribbon list, click New Tab.
In Excel, select Data > Data & Connections > Queries tab, right click the query and select Properties, select the Definition tab in the Properties dialog box, and then select Edit Query.
If you frequently create PDFs, or do something else that requires going to the File tab, here’s how to add that command to the Quick Access Toolbar. Click Customize the Quick Access Toolbar, and then click More Commands.
Add a command to the Quick Access Toolbar. On the ribbon, select the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar. Right-click the command, and then select Add to Quick Access Toolbar on the shortcut menu.
In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one. For example, you want to put the same title text into all worksheets in your workbook.
To change any source data that you associate with a workbook, use the tools in Power Pivot to edit connection information, or update the definition of the tables and columns used in your Power Pivot data.
This article explains how to manage workbook links, including how to refresh and update them, how to fix broken links, and how to work with the new security warning feature. Security Warning about workbook links
Open the Home tab and format text and numbers and use the Find tool. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. Alt+N. Open the Page Layout tab and work with themes, page setup, scale, and alignment. Alt+P
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.
Add custom tabs and groups. Select File > Options > Customize Ribbon. To add a new tab to the ribbon, select New Tab.