
COLUMNS function - Microsoft Support
This article describes the formula syntax and usage of the COLUMNS function in Microsoft Excel. Returns the number of columns in an array or reference. COLUMNS (array) The COLUMNS function …
Columns dialog box - Microsoft Support
Adjust column widths on a page - Microsoft Support
In the Columns dialog box, adjust the settings under Width and spacing to choose your column width and the spacing between columns. If you want columns of varying widths, deselect the checkbox …
Insert or delete rows and columns in Excel - Microsoft Support
You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Create columns of text in a text box or shape - Microsoft Support
Split your text into even columns by changing the text box format. No need to create a table or create separate boxes and line them up.
List and library column types and options - Microsoft Support
Columns are added to one or more views of the list or library to help you display the data in a meaningful way. Depending on your organization, additional types of column might be available. Learn about …
Hide or show rows or columns - Microsoft Support
How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.
Insert a line between columns on a page - Microsoft Support
Insert a column break to control how text flows between columns. For example, insert a column break to end a paragraph in one column and start a new paragraph at the top of the next column. Add a …
Resize a table by adding or removing rows and columns in Excel
After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table: Click …
Split text into different columns with the Convert Text to Columns ...
Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.