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
Tuesday, July 18, 2023
Tips for Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment