1. We can set auto row width and auto column width in the excel
```sh
# Ctrl+A - Select all columns (or) select particular area (set of column & rows)
# Alt+H+O+A - Set Auto Row Height
# Alt+H+O+I - Set Auto Column Width
```
2. We can apply filters for table data in Excel spreadsheet
```sh
# Ctrl+A - Select all columns (or) select particular area (set of column & rows)
# Alt+H+S+F - Apply Filters
```
3. We can apply boards to shell in Excel spreadsheet
```sh
# Ctrl+A - Select all columns (or) select particular area (set of column & rows)
# Alt+H+B+A - Apply all boarders
```
<\pre>
Azure Cloud Solution Architect, Full-Stack Development in .Net Eco system, Senior Manager at Capgemini
Showing posts with label MS-Office. Show all posts
Showing posts with label MS-Office. Show all posts
Tuesday, July 18, 2023
Tips for Excel
How to insert convert Comma\tab separated text into table
We can insert \convert comma(or) tab separted text into table ```sh # Ctrl+A - Select text to insert into table . # Alt+N+T+I - Convert into table. ``` <\pre>
Subscribe to:
Posts (Atom)