Adjusting Microsoft Excel Spreadsheet Layout and Data.
We will learn about Microsoft Excel spreadsheet layout and data. If you want to insert column and row and want to remove the row or column, or move or copy the sheet and also use find and replace commands. We will know all about in this lesson.
- Inserting and deleting rows and columns.
- Hiding and unhiding rows and columns.
- Moving, copying, and inserting data.
- Finding and replacing data.
In the Microsoft Excel spreadsheet layout, we will start from “ Inserting and deleting rows and columns”.
Click on Insert.
Insert Sheet Rows: for adding rows.
Insert Sheet Columns: for adding columns.
Or (you can use this command with right-clicking on the mouse.)
Right click on screen
Right, click on column or Row.
Hiding and un-hiding rows and columns.
Right, click on the column.
You will not see that column which you have hidden.
It shows missing column.
You can also hide multiple columns. Select more than one with mouse and ctrl key from the keyboard.
Right click and hide.
Unhide the column.
Right click on the column and unhide.
Unhide multiple columns.
Upper left the pointer.
Hide and unhide rows note: it will work like the column.
Right click on the row.
hide and unhide.
Moving, copying, and inserting data.
Finding and replacing data.
Sometimes you are looking for the data in a large list and some time actually to try to replace data.
Find: you can find any text with the find command.
Replace: you can replace any Text.
Type some text.
Shortcut key from keyboard Ctrl+f.
Ramzan I have typed in the document now I want replace with Haris.