Insert multiple rows or columns at once: Anywhere in the table, select a number of rows or columns equal to the number of rows or columns you want to insert.
TROUBLE UNHIDING ROWS NUMBERS FOR MAC BUG HOW TO
How to Hide and Unhide Columns in Excel to Optimize Your Work. How to Hide and Unhide Rows and Columns in Excel 2013. How to Hide and Unhide Rows in Excel in 2 Different Ways. Insert or delete a row or column within the table: Move the pointer over a row number or column letter, click the arrow, then choose an option from the shortcut menu. Trouble Unhiding Rows or Columns in Excel - YouTube. To delete rows and columns that have data, Option-drag. Select the Home tab from the toolbar at the top of the screen. When the GoTo window appears, enter A1 in the Reference field and click on the OK button. You can delete rows and columns only if their cells are empty. Question: How do I unhide row 1 in a sheet in Microsoft Excel 2011 for Mac Answer: Select Edit > Go To from the menu at the top left of the screen.
TROUBLE UNHIDING ROWS NUMBERS FOR MAC BUG MAC OS X
MacBook Pro, Mac OS X (10.5.5) Posted on 8:04 AM Reply I. You can delete a row or column only if all of its cells are empty.Īdd or delete both rows and columns at the edge of the table: Drag in the bottom-right corner of the table to add or delete both rows and columns. Do anybody know how to unhide selected rows only instead of unhiding all rows at once Thanks. Click in the top-right corner of the table to add a column, or drag it to add or delete multiple columns. Restore an earlier version of a spreadsheetĪdd or delete a row or column at the edge of the table: Click in the bottom-left corner of the table to add a row, or drag it to add or delete multiple rows.Save a large spreadsheet as a package file.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Functions that accept conditions and wildcards as arguments.String operator and wildcards in formulas.
Quickly calculate a sum, average, and more.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.Add checkboxes and other controls to cells.Intro to images, charts, and other objects.