Formatting
Create a table
What is a table? Table allows you to organize, analyze and format data swiftly. You can sort, filter, and summarize information to gain insights and maintain layout. How to create a table To create a table: Go to Insert > Table . Select the range you ...
Apply themes to your spreadsheet
Themes let you style your entire spreadsheet at once—from font colors and cell fills to charts, tables, and more. How to apply a theme to your spreadsheet To apply a theme to your spreadsheet: Go to Page Layout > Themes Select one of the predefined ...
Freeze/Unfreeze panes
Freeze panes keep a selected range or column headers visible when you scroll through large sets of data. How to freeze rows/columns To freeze column/rows: Go to the View tab. You can freeze specific parts of the sheet using the following options: Use ...
Group and ungroup rows or columns
Grouping rows or columns and expanding them when needed helps keep your spreadsheets organized. Here's how you can do it: How to group columns/rows Select the rows/columns you wish to group. Go to Data > Group From the drop-down, select Group ...
How to covert text into columns
To convert text into columns Select the cell range that has the text you wish to convert into columns. Go to Data > Text to Columns . Choose the delimiters, such as comma, space, or tab, that you want to use to split the text into columns. Set the ...
Shift cells
Shift cells down/right To shift cells in your spreadsheet: Select the cell you wish to shift. Right-click on the cell, and select Insert > Shift cells Down/Right from the contextual menu. Alternatively, go to Home > Insert and select Shift cells ...
Rotate text
To rotate text or data in a cell: Select the cell or the range of cells that you wish to rotate. Under the Home menu, tap to choose the desired option from the available options. You can also select the custom option to customize the tilt angle.
Insert or delete rows or columns in a sheet
Insert a row or column in your spreadsheet To insert a row or column: Select a row or column in your spreadsheet where you wish to insert a row. Go to Home > Insert . From the drop-down, choose Insert Row or Insert Column as needed. Alternatively, ...
Gridlines
How to change grid direction in your spreadsheet To change grid direction in your spreadsheet: Go to View > Grid Direction. Choose whether you want the grid to flow left to right or right to left. How to modify spacing for gridlines To adjust spacing ...
Format cells
To format data in a cell: Select the cell or the range of cells you wish to format. Tap the Home menu and select any formatting options, such as Bold, Italics, Underline, Strikethrough, Font Family, Font Size, or Color.
Merge your cells
Merge cells lets you combine two or more cells into a single, larger cell. It is often used to title a group of related cells. To merge cells in your spreadsheet: Select the cell range you wish to merge. Under the Home menu, click . Select any ...
Wrap text
Wrap text allows you to fit your data within your cell, displaying it on multiple lines. Without it, the text that exceeds the cell width will overflow into the adjacent cell. There are three types of text wraps: Wrap- The text will be wrapped inside ...
Apply cell borders
Borders help visually group similar cells and draw attention to important details. Here's how you can apply them to your data: Select the range of cells that you wish to apply borders to. Click under the Home tab. From the Borders dialog, you can ...
Highlight your text
To highlight important text in your spreadsheet, apply background color to the selected cells or change the font color to make it more visible. Here's how you can do it: Select the cells you want highlighted. On the Home tab, try one of these: To ...
Increase and decrease indent
To increase or decrease indent in a cell: Select the cell or the range of cells that you wish to increase or decrease the indent. Under the Home menu, tap to increase indent and to decrease indent to adjust the text position within the cell.
Align your text
Proper text alignment ensures your data looks organized and improves readability. Here's how you can do it: Select the cells that you want aligned. Go to the Home tab and select one of the following options: To horizontally align your text, choose ...