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

  
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>

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>