Introduction

Having discussed different ways of creating sheets in the previous article How To Create Sheets In TruDRIVE, it's just about time to find out how to use TruDRIVE Sheets, i. e. how to manipulate columns, rows, and cells. This will be especially useful for those who never worked with spreadsheets before. This article covers the following aspects:

Working With Columns

Extending A Column

To extend a column, hover over the right border of its header until the cursor turns into a double-headed arrow (See Figure 1). Then drag it to the right if you want to extend the column, or to the left if you want to shrink it. Once the width of the column reaches the desired size, release the left mouse button.

null

Figure 1. Extending A Column

 

Cutting A Column

To cut a column, click on its header with the right mouse button and select Cut in the context menu (see Figure 2). The column will be copied to clipboard, and its content will be deleted once you paste it. Another way to cut a column is to select it by clicking on its header with the left mouse button and press Ctrl+X on the keyboard.

null

Figure 2. Cutting A Column

 

Copying A Column

To copy a column, click on its header with the right mouse button and select Copy in the context menu (see Figure 3). The column will be copied to clipboard, and its content will be duplicated once you paste it. Another way to copy a column is to select it by clicking on its header with the left mouse button and press Ctrl+C on the keyboard.

null

Figure 3. Copying A Column

 

Pasting A Column

To paste a column from the clipboard, click on the header of the column you want to replace with the right mouse button and select Paste in the context menu (see Figure 4). The column on which you clicked will be replaced with the column stored in the clipboard. Another way to paste a column is to select the column you want to replace by clicking on its header with the left mouse button and press Ctrl+V on the keyboard.

null

Figure 4. Pasting A Column

 

Inserting One Column Left

To insert an empty column to the left of another one, click on the header of that column with the right mouse button and select Insert 1 Left in the context menu (see Figure 5). An empty column will appear to the left of the column on which you clicked. All the columns to the right of the empty one will get shifted one column right.

null

Figure 5. Inserting One Column Left

 

Inserting One Column Right

To insert an empty column to the right of another one, click on the header of that column with the right mouse button and select Insert 1 Right in the context menu (see Figure 6). An empty column will appear to the right of the column on which you clicked.  All the columns to the right of the empty one will get shifted one column right.

null

Figure 6. Inserting One Column Right

 

Deleting A Column

To delete a column, click on its header with the right mouse button and select Delete Column in the context menu (see Figure 7). All the content of that column will be deleted, and all the columns to the right of it will get shifted one column left. Note: if you select the column by clicking on its header with the left mouse button and press Delete on the keyboard, only the content of that column will be deleted, but the empty column will stay where it was.

null

Figure 7. Deleting A Column

 

Clearing A Column

To clear a column, click on its header with the right mouse button and select Clear Column in the context menu (see Figure 8). All the content of that column will be deleted. Another way to clear a column is to select it by clicking on its header with the left mouse button and press Delete on the keyboard.

null

Figure 8. Clearing A Column

 

Hiding A Column

To hide a column, click on its header with the right mouse button and select Hide Column in the context menu (see Figure 9). The column will be hidden, and two arrows will appear on the headers of the two columns that were on the sides of the hidden one. To unhide the column, click on either of those arrows.

null

Figure 9. Hiding A Column

 

Working With Rows

Extending A Row

To extend a row, hover over the lower border of its header until the cursor turns into a double-headed arrow (See Figure 10). Then drag it down if you want to extend the row, or up if you want to shrink it. Once the height of the column reaches the desired size, release the left mouse button.

null

Figure 10. Extending A Row

 

Cutting A Row

To cut a row, click on its header with the right mouse button and select Cut in the context menu (see Figure 11). The row will be copied to clipboard, and its content will be deleted once you paste it. Another way to cut a row is to select it by clicking on its header with the left mouse button and press Ctrl+X on the keyboard.

null

Figure 11. Cutting A Row

 

Copying A Row

To copy a row, click on its header with the right mouse button and select Copy in the context menu (see Figure 12). The row will be copied to clipboard, and its content will be duplicated once you paste it. Another way to copy a row is to select it by clicking on its header with the left mouse button and press Ctrl+C on the keyboard.

null

Figure 12. Copying A Row

 

Pasting A Row

To paste a row from the clipboard, click on the header of the row you want to replace with the right mouse button and select Paste in the context menu (see Figure 13). The row on which you clicked will be replaced with the row stored in the clipboard. Another way to paste a row is to select the row you want to replace by clicking on its header with the left mouse button and press Ctrl+V on the keyboard.

null

Figure 13. Pasting A Row

 

Inserting One Row Above

To insert an empty row above another one, click on the header of that row with the right mouse button and select Insert 1 Above in the context menu (see Figure 14). An empty row will appear above the row on which you clicked. All the rows below the empty one will get shifted one row down.

null

Figure 14. Inserting One Row Above

 

Inserting One Row Below

To insert an empty row below another one, click on the header of that row with the right mouse button and select Insert 1 Below in the context menu (see Figure 15). An empty row will appear below the row on which you clicked. All the rows below the empty one will get shifted one row down.

null

Figure 15. Inserting One Row Below

 

Deleting A Row

To delete a row, click on its header with the right mouse button and select Delete Row in the context menu (see Figure 16). All the content of that row will be deleted, and all the rows below it will get shifted one row up. Note: if you select the row by clicking on its header with the left mouse button and press Delete on the keyboard, only the content of that row will be deleted, but the empty row will stay where it was.

null

Figure 16. Deleting A Row

 

Clearing A Row

To clear a row, click on its header with the right mouse button and select Clear Row in the context menu (see Figure 17). All the content of that row will be deleted. Another way to clear a row is to select it by clicking on its header with the left mouse button and press Delete on the keyboard.

null

Figure 17. Clearing A Row

 

Hiding A Row

To hide a row, click on its header with the right mouse button and select Hide Row in the context menu (see Figure 18). The row will be hidden, and two arrows will appear on the headers of the two rows that were above and below the hidden one. To unhide the row, click on either of those arrows.

null

Figure 18. Hiding A Row

 

Working With Cells

Cutting A Cell

To cut a cell, click on it with the right mouse button and select Cut in the context menu (see Figure 19). The cell will be copied to clipboard, and its content will be deleted once you paste it. Another way to cut a cell is to select it by clicking on it with the left mouse button and press Ctrl+X on the keyboard.

null

Figure 19. Cutting A Cell

 

Copying A Cell

To copy a cell, click on it with the right mouse button and select Copy in the context menu (see Figure 20). The cell will be copied to clipboard, and its content will be duplicated once you paste it. Another way to copy a cell is to select it by clicking on it with the left mouse button and press Ctrl+C on the keyboard.

null

Figure 20. Copying A Cell

 

Pasting A Cell

To paste a cell from the clipboard, click on the cell you want to replace with the right mouse button and select Paste in the context menu (see Figure 21). The cell on which you clicked will be replaced with the cell stored in the clipboard. Another way to paste a cell is to select the cell you want to replace by clicking on it with the left mouse button and press Ctrl+V on the keyboard.

null

Figure 21. Pasting A Cell

 

Clearing A Cell

To clear a cell, click on it with the right mouse button and select Clear Cell in the context menu (see Figure 22). All the content of that cell will be deleted. Another way to clear a cell is to select it by clicking on it with the left mouse button and press Delete on the keyboard.

null

Figure 22. Clearing A Cell

 

Conclusion

Hopefully, after reading this article you will have no more questions left on how to work with TruDRIVE Sheets. We learned how to manipulate columns, rows, and cells using not only a context menu, but also keyboard shortcuts. To learn more about TruDRIVE, please see the article Getting Started With TruDRIVE.