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