How to use Excel 2007: 11 steps

wikiHow is a wiki, which means that many articles are written by several authors. To create this article, volunteer authors participated in the editing and improvement. Microsoft Excel is the spreadsheet included in Microsoft Office. Excel 2007 has a different interface than previous versions and requires some adaptation time. Whether it’s the first time you’re using Microsoft Excel 2007 or Excel spreadsheets in general, start by creating a simple spreadsheet and reviewing the various options menus to learn how to use them. Steps 1 Familiarize yourself with the features of Microsoft Office 2007. Learn how to register and open files, use help functions, print, and other common Office tasks before you learn more about using Excel 2007. 2 Left-click on a cell. Enter the desired text or numbers in the cell. Click on another cell or press Enter to finish. 3 Make the cells wider or longer. Click a line between columns or rows and hold down the left mouse button until the pointer becomes an arrow. Drag the columns or rows to make them wider. To make all columns or rows wider, click on the square at the top left (all cells will be highlighted). Adjust the width or length of a column or row to apply the changes to the entire workbook. 4 Learn how to make a selection. To apply the changes to a group of cells, left-click on the first cell in the workbook. Hold down the mouse button and drag the cursor to the last cell you want to select. All cells will be highlighted and you can apply the changes to all at the same time. 5 Change the appearance of the cells. Left-click on the top cell and drag the slider to select all cells in the workbook. Go to the Home tab at the top of the screen and click Style. Choose a cell and font color from the options. Change the style and font size for the entire selection. Next to the default font, click the down arrow. Select a new font and do the same for the font size. 6 Choose one of the options in the Alignment section. To center or align cell data, click one of the options in the Alignment section. Choose Automatically wrap to enter all the data in a cell and change their size automatically. 7 Change the cell format. Go to the Number section to change the cell format to text, number, time, or other option. For further editing (for example changing the time format or number of decimal points), select Other Digital Formats at the bottom of the menu. Under Category, make a selection and change the options under the Type heading. 8 Add an image to a cell. Use the Insert menu to add an image, shape, chart, or other object to a cell in the workbook. If you want to insert a link to a website, another binder or another document, use the Links option. 9 Edit the layout of your workbook. Left-click on the Layout menu to adjust margins, add page breaks, or move the portrait-to-landscape orientation. In the Spreadsheet Options section, you can determine how the gridlines (the lines around each cell) appear when viewing or printing. 10 Experiment with the different formulas. Go to the Formulas tab, click on the Fx icon to insert a function. A list of functions will appear, each with a link that will give you more information about the selected function. To quickly add numbers to a column, highlight the cells to add and click AutoSum. You can also apply this formula on multiple columns. The sum will be displayed in the cell under the selection. 11 Sort or filter the data. In the Data tab, you …


Leave a Reply

Your email address will not be published. Required fields are marked *