Tuesday, July 18, 2023

Tips for Excel

  
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>

No comments:

Post a Comment