how to unhide columns in openoffice calc

On the Group dialog, you can choose whether to group the selected cells by rows or columns. Otherwise, you can set outline groups manually by selecting the cells for grouping, then choosing Data > Group and Outline > Group. If the contents of cells falls into a regular pattern, such as four cells followed by a total, then you can use Data > Group and Outline > AutoOutline to have Calc add outline controls based on the pattern. If you are continually hiding and showing the same cells, you can simplify the process by creating outline groups, which add a set of controls for hiding and showing the cells in the group that are quick to use and always available. So altogether there are 26 + 676 + 15,682 = 16,384 columns.Hiding or showing cells Outline group controls So the three-letter column names run from 0 to 15,681, so there are 15,682 of them. So X is the 23 digit, F is the 5 digit, and D is the 3 digit, and XFD is the base-26 for 23×262+5×26+3×1=15,681 Treat A as the 0 digit, and Z as the 25 digit in base 26 numerals. Treat AAA like 000 in base 26 arithmetic. Then start the columns with 3-letter names. So how many columns is that?Ĭolumns labeled A through Z, and then there are 262=676 columns labeled AA through AZ. To find out how many columns, you can press CTRL-Right-Arrow key combination in an empty worksheet, and you will find yourself at column XFD.

The cursor will move all the way to the bottom row of the sheet. To find out how many rows, you can open an empty worksheet, and press CTRL-Down-Arrow key combination on your keyboard. Versionįor MS Excel 2010, Row numbers ranges from 1 to 1048576 in total 1048576 rows, and Columns ranges from A to XFD in total 16384 columns.Ĭolumns in an an Excel worksheet, at least since Excel 2007.

Below is a list of the maximum number of rows, columns, cells, and individual sheets supported by various spreadsheet software. The number of cells, columns, rows, and sheets supported by a spreadsheet depend on the software being used, and the data contained in the spreadsheet. It depends on the Excel version you are using.

How to unhide columns in openoffice calc