If you want to learn how to do a spreadsheet on Word, then this article is for you. It will give you step by step instructions on how to convert Microsoft Excel into a spreadsheet for the different purposes. This will be useful for any business and especially for those who can’t open Microsoft Excel due to its restrictions or features.
But you might be wondering how to do it. Keep reading if you want to know more about this matter
First of all, it is a good idea to open Word and save your work on it. It is recommended that you do so with the shortcut Ctrl + F11. This will let you choose the different tables and cells you need to open.
How to Do a Spreadsheet on Word?
Once you have opened the Table of Contents section, you can change the tabs. Start selecting the tab you want to change. You can use the arrow keys to change the selected tab. Just remember that a tab represents a row, while the next one is a column.
Select the column that you want to change and click the pencil icon to get rid of the last selected column. This is because you are going to select a new cell that is going to be filled with the data that you need.
Once you have done the same for the selected cell, then you can change the sheet header to change the appearance of the sheet. You can use the tab key to get rid of the column heading and select the top line of the column that you want to change.
Once you have clicked the arrow, you can change the selected cell, using the drop down menu. Now you can add a new column by selecting the cell that you want to fill with the new data.
Once you have got the new sheet, you can format it. Open the Format menu and select the colors menu. Now you can apply the colors that you want to make the sheet look like what you want.
Open the Table of Contents section and get rid of the worksheet that is being shown there. It is going to show only the data you have chosen.
Select the cell where you want to have the worksheet. After you have done this, you can copy the code that you want to use in the new sheet. It is recommended that you use a clipboard as you will want to see the changes on the new sheet before you do them on the old one.
Once you have copied the codes, you can use the delete and move buttons to get rid of the old sheet and replace it with the new one. After that, you can save the new sheet and then print it.
This is how to do a spreadsheet on Word. Try it out and I am sure you will like the result! PLEASE SEE : how to create an expenses spreadsheet