Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.Ĥ7. Ctrl + Shift + O: To select the cells containing comments.Ĥ6. Ctrl + Shift + F: To open the fonts menu under format cells.Ĥ5. Ctrl + Shift + Tab: To switch to the previous workbook.Ĥ4. Ctrl + Shift + Spacebar: To select an entire workbook.Ĥ3. Ctrl + Spacebar: To select an entire column.Ĥ1. Ctrl + -: To delete a selected row or column.Ĥ0. Ctrl + Shift + &: To place borders around the selected cells.ģ8. Ctrl + Shift + %: To apply percentage formatting.ģ7. Ctrl + Shift + #: To apply date formatting.ģ6. Ctrl + Shift + $: To apply currency formatting.ģ5.

Ctrl + Shift + !: To apply comma formatting.ģ4. Ctrl + Shift + To apply time formatting.ģ3. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.ģ2. Ctrl + Shift + =: To insert columns and rows.ģ1. Ctrl + ‘: To copy the formula from the cell above.ģ0. Ctrl + `: To change the view from displaying cell values to formulas.Ģ8. Ctrl + : To enter the current date in a cell.Ģ7. Ctrl + Shift + :: To enter the current time in a cell.Ģ6. Ctrl + 8: To show the outline symbols.Ģ5.

Ctrl + 5: To put a strikethrough in a cell.Ģ2. Ctrl + 1: To format the cell contents.Ģ1. Ctrl + W: To close your current workbook.Ģ0. Ctrl + V: To paste anything that was copied.ġ8. Ctrl + U: To underline highlighted cells.ġ7. Ctrl + R: To fill the selected cell with the content of the cell on the left.ġ6. Ctrl + L: To open the create table dialog box.ġ5. Ctrl + K: To insert a hyperlink in a cell.ġ3. Ctrl + H: To find and replace cell contents.ġ1. Ctrl + G: To jump to a certain area with a single command.ġ0. Ctrl + F: To search for anything in a workbook.ĩ. Ctrl + D: To fill the selected cell with the content of the cell right above.Ĩ. Ctrl + C: To copy cells that are highlighted.ħ. Ctrl + B: To turn highlighted cells bold.Ħ. Ctrl + A: To select all the contents in a workbook.ĥ. However, we have picked out some of the most useful shortcuts, and we hope this would be worth your time.Ĥ. In some situations, the drawing data might not link correctly to the data in the spreadsheet.Before you proceed, note that the list is pretty long but it is by no means a complete list consisting of all the Excel shortcuts. If the match is unsuccessful, a warning message indicates what the problem is. You can test if the data matching is valid by clicking the Check Match button from the Link External Data dialog box. Because there is at least one cell of matching data in the drawing data column and the external data column, the data extraction feature “knows” how both sources are tied together. In the Link External Data dialog box, you select Part # as the column for the drawing data and Catalog Number as the column for the external data. In this example, the spreadsheet contains a column of part numbers labeled Catalog Number that matches the Part Number column in the extracted data. These columns contain data for Cost and Supplier. You want to include two additional columns of data in the BOM from a spreadsheet. These columns contain data for: Part #, Revision, and Quantity. Three columns of data are extracted from a drawing. See Link a Table to External Data for more information about data linking.ĭata matching creates a relationship between two sets of data the data in a column from the extracted drawing data and the data in a column from an Excel spreadsheet.įor example, you have a simple bill of materials (BOM). Likewise, if a change is made to the table in the drawing, the linked spreadsheet can be updated using the same command.ĭata linking is the process of selecting a Microsoft Excel spreadsheet with the purpose of merging all or some of its contents with extracted drawing data. If a linked spreadsheet has been changed, such as a row or column has been added, the table in your drawing can be updated accordingly using the DATALINKUPDATE command. If Microsoft Excel is not installed, or if the XLS file is not saved locally on the computer that is performing the data extraction, a data link cannot be established. On the Refine Data page, you access the Link External Data dialog box you can set up a link to an entire Excel spreadsheet, or to a range of rows and columns, to the extracted data.īefore you can link a spreadsheet, Microsoft Excel needs to be installed on the same computer on which the data extraction is performed.

Select the columns in the XLS file to merge with the extracted drawing data.

Match the extracted drawing data and the spreadsheet data.

Specify a data link by selecting an XLS file to which the extracted data from the drawing will be linked.

Using the Link External Data dialog box, you can: By linking to an Excel spreadsheet, you can include information from an entire worksheet, or part of a worksheet, referred to as a

Excel for mac column numbers