You saw that by clicking inside of a cell it makes it active, so that you can make changes. We want to Centre all our numbers and the text. Here's the spreadsheet we have: So, we need cells A1, A2, A3 and A4 to be active. In Excel, you can do this by highlighting the cells. Place your mouse over cell A1. Your pointer should now be in the shape of a white cross. When your pointer changes to the white cross, hold your left mouse button down and drag to cell A4. Let go of the left mouse button when cells A1, A2, A3 and A4 are highlighted. The image below shows what you are aiming for. The cells highlighted in the image above have a different color to the normal white color of a cell. When you highlight cells, you can do things to all the cells as a group. To Centre the text and numbers in our highlighted cells, t...
For Windows 8/10 users 1. Go to the Start Button on the Desktop and press ALL apps . 2. Then click on Excel. 3. This opens the Excel program Identifying the items on the Excel program screen: Menu bar: 1. Menu bar contains all the operators which the user wishes to perform on their Data. 2. By clicking on each tab user and view the operator. Example: By clicking on Home tab user can see the operators which allow changing the Font type, size, and color. Toolbars: 1. A wide variety of toolbars displaying buttons which make editing quicker and easier are available. 2. Usually Toolbars have only three options: Save, Undo and Redo. Users have an option of adding any tool they wish to have in Toolbar by simply Customizing the Toolbar. Customizing Toolbars: 1. By clicking on the small down arrow present beside Toolbar users can Customize Toolbar. 2. From the available options, user can select any option by clicking on them. The File tab. ...
When Excel starts up, the program will display a new, blank workbook. This is fine, but you do not always have to build everything up from scratch. Alternatively, you can start a new spreadsheet manually, using various templates. 1. Click on the File tab in the top left corner of the screen. 2. Click on New. You will now choose which template you want to use. Templates for invoicing budgeting and even monitoring of blood pressure have already been installed. If you do not think the preinstalled templates are enough, it is possible to download many more via the search bar. Navigating the spreadsheet You can use both mouse and keyboard to navigate the worksheet, but I recommend that you practice using the keyboard. It is a faster and economically better solution. You'll need to move things around a lot in the spreadsheet, and if you always use the mouse, you could easily develop a "mouse-arm." Using the ke...
Comments
Post a Comment