1. In order to protect your Microsoft excel worksheet go to TOOLs menu select PROTECTION. From there you should see a menu like the picture on your left.2. From there you will be given a series of options that will allow you to protect a Microsoft excel worksheet, workbook or a range on your specific file. As you can see from the image on your left you can get very granular with this.3. Make your appropriate adjustments and then click OK. You should be prompted to retype the password. Once that is done make sure you save your changes and close the document and reopen it to see if your password...
Browse » Home » All posts
Sunday, December 15, 2013
Saturday, December 14, 2013
How to Create a Box Plot in Microsoft Excel 2007
Set Up the Plot Data1. Create a table with a column for each data set. In the table rows, add formulas for the calculations of (in order) the minimum, first quartile, median, third quartile and maximum for each data set using the Excel functions MIN, MAX, MEDIAN and QUARTILE (or PERCENTILE). This is the 'summary table.'2. Create a second table with the same rows and columns as above. This table will contain the values used for the plot. This is the 'plot data table.'3. Add a formula for each data set's maximum value in the plot data table that is the maximum minus the third quartile values...
How to Do Percentages With Excel 2003
1. Open Excel 2003, and open a workbook that contains a column with amounts and another column with totals. Click 'File' on the menu bar, and click 'Open.' Browse your files, and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Click in the next available column in your workbook. Type '=.' Click in the first cell that contains the first amount. Type '/.' Click in the first cell that contains the first total, and press the 'Enter' key. A value is generated.3. Highlight the column containing this new formula. Click the '%' symbol on the...
How to Maximize a Sheet in Excel 2007
1. Open an Excel worksheet by clicking on the round 'Office' button in the top left-hand corner of Excel 2007. Select 'Open' from the drop-down menu on the left. Choose the file name of the Excel document that you wish to open.2. Click on the 'maximize' button in your Excel work window. You'll find it just to the left of the 'close' button in the top right corner. An 'X' identifies the close button, and a square, the maximize button. The maximize function changes your worksheet to maximum size within your open Excel document.3. Click on the 'restore down' button to make your worksheet smaller....
Friday, December 13, 2013
How to Sort and Filter in Microsoft Excel
1. Open Microsoft Excel and go to 'File' and 'Open' to open the document containing data you want to sort and filter. Highlight the document and click 'Open.' The document will open in a new window.2. Highlight the data you want to sort. You may select an entire worksheet, a column, multiple columns or specific data within a column.3. Complete a simple sort by selecting the 'Home' tab from the ribbon and from the 'Editing' group selecting 'Sort and Filter.'4. Click the appropriate option that matches your preferred sort. For example, if your data is a group of dates, click 'Sort Oldest...
How to Use Absolute References in Microsoft Excel
1. Enter a value into the cell you want to keep constant.2. Select another cell in the Excel spreadsheet for the formula that will use the absolute reference.3. Enter the formula. Use the dollar sign ($) in front of the row reference to keep to keep the row absolute or in front column reference to keep it absolute. For instance, '$C$21' is an absolute reference for cell 'C21,' while 'C$21' an absolute reference to row '21' but but a relative reference column '...
Thursday, December 12, 2013
How to Convert Word to Excel 2007
1. Launch Microsoft Word and open the document that you want to convert to Excel. Click once on the Microsoft Office button and select the 'Open' option. Locate the folder in which the document is saved in the 'Look in' section of the 'Navigation Pane.' Double click on the file name to open it. If you do not have either program, a free trial may be downloaded from the Microsoft site.2. Save the Word document as a text (TXT) file. Click once on the Microsoft Office button and select the 'Save As' option. Select a folder in which to save the text file using the 'Save in' menu. Use the 'Save...
How to Unlock Grayed Out Menus in Excel 2007
1. Position your cursor so that it is on one of the sheet tabs at the bottom of the screen. Make sure the sheet tab is highlighted.2. Right-click the sheet tab. Choose 'Ungroup Sheets' from the drop-down menu.3. Click one of the menus. All of the options should now be visible. If the options are still grayed out, right-click the sheet tab again and choose 'Ungroup Sheet...
How to Remove a Contribute Toolbar From Excel 2003
1. Open Excel. Customizations to the toolbar interface are always accomplished within the program. However, it does not matter what file is opened within Excel, or if the program window is open without any files loaded.2. Locate the 'Contribute' toolbar. It is important to see the toolbar when it is active so you can easily verify if the removal process was successful. As there are many toolbars, removing a single toolbar is not always obvious unless you are aware of its precise location in the program window.3. Click the 'View' menu. Select the 'Toolbars' submenu. If the 'Toolbars' submenu...
How to Open WB3 Files in Excel 2003
1. Launch 'Excel.'2. Go to 'File.' Select 'Open,' choose 'Quattro Pro/DOS' from the 'Files of Type' drop-down menu. Navigate to the folder where your WB3 file is located, and double-click to select the file.3. Go to 'File,' and select 'Save As.' Choose 'Excel 97-2003 Workbook (*.xls)' from the 'Save as Type' options. Click 'Sav...
How to Create Mailing Labels From an Excel Database
1. Open Microsoft Word. Click the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels.' The 'Label Options' dialog box will open, where you can set up the labels.2. Select the type of printer you are going to use under 'Printer Information.' Click the 'Label Vendors' list and select the manufacturer of your label sheets. Select the product number listed on your label sheet packaging from the 'Product Number' list. Click 'OK.' The sheet of labels is set up as a table in your document.3. Click the 'Mailings' tab, then 'Select Recipients' in the 'Start Mail Merge' group. Click 'Use...
Wednesday, December 11, 2013
How to Set Up Formulas in Excel 2007
1. Click the cell where you want to display the results.2. Press '=' on your keyboard to start a formula.3. Add a parenthesis and the name of the first cell you want to include in your formula. For example, your formula to this point should look something like this: =(A14. Add the operator -- ' ,' '-,' '*' or '/' -- you want this formula to perform. For example, =(A1 5. Type the location of the next cell for your formula and repeat Steps 3 and 4 -- minus the parenthesis -- until you have listed all the cells you want to include in your formula. For example, =(A1 A2 B1 B2 C1 C26. Add...
How to Change Appearance in Excel 2007
1. Choose a document theme to unite all of your Office 2007 programs with the same look. A document theme shares the same colors, fonts, lines, fill effects and other style choices. Select a document theme from the available choices or create a new document theme by going to Page Layout and selecting 'Themes.' Click on a document theme from 'Built-in' or 'Custom.' When you create a custom theme, save it under a new name.2. Click Page Layout View to adjust margins or add headers and footers. This feature is similar to the Print Layout view in Word.3. Use the different style choices to change...
How to Recover an Excel File That Was Saved Over
Using AutoRecover1. Click 'Start' and then 'Search.'2. Select 'All Files and Folders' when asked what you want to search for.3. Type in '*.xls' (without the quotation marks) under 'All or Part of the File Name.'4. Click on the arrow next to 'More advanced options' and make sure that the file type reads 'All Files and Folders.'5. Click the boxes next to 'Search System Folders' and 'Search Hidden Files.'6. Click 'Search.'7. Look for an earlier version of your file (it should have a similar name). When it appears, open it to see if it is the version you wa...
How to Freeze Rows Columns
1. Place the cursor in the cell directly below the row you want to remain visible (freeze) and directly to the right of the column you want to remain visible (freeze). For example, if you want Row 1 and Columns A through C to remain visible (freeze), place the cursor in cell D2.2. Click on the 'Window' menu.3. Select 'Freeze Panes.'4. Move the cursor through the spreadsheet and notice that Row 1 and Columns A through C are frozen. In other words, they always remain visible while the rest of the data move.5. Click on the 'Window' menu and select 'Unfreeze Panes' to remove the frozen...
Subscribe to:
Posts (Atom)