Locking1. Open the Excel spreadsheet you want to lock.2. Click the green 'File' tab on the ribbon.3. Click the large, square 'Protect Workbook' button.4. Select a permissions level. Choose 'Mark as Final' to make the spreadsheet read-only. This option does not require a password and only discourages, but does not prevent, editing.5. Choose 'Encrypt with Password' if you want to prevent anyone from opening the spreadsheet without a password. Type the password in the box and click 'OK.' Excel will prompt you to re-enter the password. Re-enter the password and click 'OK' again.6. Choose...
Browse » Home » All posts
Sunday, May 20, 2012
How to Convert Quattro Pro for Windows to Excel
1. Go to 'My Computer' and double-click on 'Control Panel.'2. Double-click on 'Add/Remove Programs' to open the list of installed programs on your PC. Wait for the list to be propagated before doing anything.3. Search for Microsoft Excel. If you installed Excel as part of an MS Office suite, look for Microsoft Office instead. Click on the program to bring up a list of options on the right side of the window.4. Click the 'Add/remove' button among the list of options. This opens up an installation wizard.5. Click on the 'Add or Remove Features' option in the window that appears to bring...
Saturday, May 19, 2012
How to Use the Inverse Log Function in Excel
1. Start Excel.2. Generate the inverse of a common -- base 10 -- logarithm in cell 'A1' by typing '=POWER(10,B1)' and entering the logarithm desired in cell 'B1.' You can replace the first 10 inside the parentheses with any base you choose.3. Generate the inverse of a natural logarithm -- base 2.8172 -- in cell 'A2' by typing '=EXP(B2)' and entering the logarithm desired in cell 'B...
How to Make a Cumulative Frequency Table
1. Construct your spreadsheet to have three columns. One of these columns will be your observation interval, the second will be the number of observations you make per interval, and the third will be the cumulative frequency column.2. Construct your table to contain as many rows as you have observation intervals (e.g., if you are going to make an observation every hour for one day, you will have 24 rows).3. Write your observation intervals down in the first column. As in the above example, if you are making an observation each hour for one day, your 24 rows in this column will be numbered...
How to VLookup Two Values in Excel 2007
1. Open the Excel 2007 file that contains the table you want to work with.2. Right-click on the column letter above the leftmost column on your table. Choose 'Insert' to create a new column.3. Select the top cell in your new column. Type '=XXYY' into the cell, where 'XX' equals the cell reference to the first cell in the first column you want to search through with VLookup, and 'YY' is the second column. Press 'Enter' and you will see the entries in those columns compressed together into the new column. For example, if 'here' was in the first column, and 'there' was in the second, your new...
How to Remove the Blanks from a Pivot Table Add
Remove Blank Cells1. Open Excel and open 'Pivot Table Options' in the Excel ribbon by clicking anywhere on the Pivot Table.2. Click 'Pivot Table Options' to open the options box so you can make changes to the Pivot Table settings.3. Click the 'Layout Format' tab and look to the 'Format' section.4. Uncheck the box next to 'For empty cells show:' and then click 'OK.' Blank cells will no longer show up in the Pivot Table add-in.Remove Blanks from Rows5. Click on the Pivot Table report to open 'Pivot Table Options' in the Excel ribbon.6. Look to the 'Active Field' section of the ribbon...
How to Use the Same Color for Multiple Line Charts
1. Turn on your computer and open Excel. Microsoft Excel is a spreadsheet program that helps you maintain data and compile charts, tables and graphs in a few easy steps. This program is available for PC and Mac computers and we will look at creating a graph in Excel.2. Enter the data you want to include in your chart in the Excel spreadsheet. This is easy to do. You will place your 'Y-axis' data on the first vertical column and the 'X-axis' data across the first horizontal row. Start The vertical column on the second row so that you can place the information in each data box. For example,...
Friday, May 18, 2012
How to Create the Input Form on Excel 2007
1. Plan your worksheet. Think about the type of information you will be keeping in the spreadsheet and set up your columns.The column headers will be used as the form labels next to the input boxes.2. Set up your spreadsheet. Type in the column headers. Set the column lengths. Do not merge any cells in the column headers. Excel will not be able to generate an input form from merged cells. You can always make the columns bigger by changing the column width property.3. Add the Form button to the Quick Access toolbar. Click the drop-down arrow on the Quick Access toolbar and then click 'More...
Thursday, May 17, 2012
How to Find Blank Cells in a Column in MS Excel
Sort Method1. Open the Excel file that you want to work with. Select the correct spreadsheet from the list of sheets at the bottom of the window. Click on any cell in the column where you are looking for blank cells.2. Click the 'Data' tab at the top of the window. Locate the 'Sort Filter' area of the ribbon.3. Select either the 'ZA' button, to sort the information from largest to smallest, or the 'AZ' button, which will do the opposite.4. Click on any cell in the column you just sorted. Move your mouse to the very bottom of the selected cell, so that the pointer changes into a set of...
How to Unlock a File in Excel 2007
1. Open the Excel file.2. Click the 'Review' tab on the command ribbon.3. Click the 'Unprotect Sheet,' 'Unprotect Workbook' or 'Unprotect Shared Workbook' button in the 'Changes' group.4. Type the password if a dialog box opens. Click 'OK.'5. Edit the unprotected file.6. Press 'Ctrl S' to save this fi...
How to Convert Military Time on an Excel Spreadsheet
1. Select the cell with military time. Place your mouse over the cell. Click your left mouse button once to select the cell. The cell is active when outlined with a black border. In addition, the status bar will indicate 'Ready' in the lower-left corner of the program window.2. Right-click the cell. Open the short-cut menu by right-clicking the cell. Click 'Format cells...' from the short-cut menu. The 'Format Cells' dialogue box will open.3. Choose a format. Make sure the current tab is 'Number.' Select 'Time' from the 'Category' section of the 'Number' tab. In the 'Type' section, select...
How to Make a Button for a Macro in Excel
1. Open the Excel 2010 spreadsheet where you want to add a macro button. Click the 'File' tab at the top of the screen and choose 'Options' from the list items on the far-left side of the screen.2. Select 'Customize Ribbon' on the 'Options' window. Locate the 'Developer' entry in the rightmost column under the 'Customize the Ribbon' heading. Click the empty box next to 'Developer' to add that tab to the Excel ribbon. Click 'OK' to go back to the spreadsheet.3. Click the 'Developer' tab at the top of the Excel spreadsheet. Locate the 'Controls' area of the ribbon and click the 'Insert' button....
How to Use the Multiple Rows Function in Excel
1. In Excel, place your cursor in an empty cell located below the group of numbers that you would like to reference.2. Click on the 'Function' key located to the left of the Formula task bar.3. Select 'Rows' from the Function list.4. Click 'OK'.5. Highlight the section of rows containing the set of numbers you would like to add or enter the row and column reference points in the Formula bar.6. Click 'OK' to exit.7. Test the formula's accuracy by adding a couple of new rows. Highlight two rows within the middle of the range. To do this, left-click your mouse and hold down the 'Down-Arrow...
Tuesday, May 15, 2012
How to Duplicate Words in Excel
1. Double-click the icon on the desktop or click 'Start,' 'All Programs,' 'Microsoft Office' and Microsoft Excel 2010' to launch Microsoft Excel.2. Type a word into the first cell and press 'Enter' to accept the entry and move to the next cell down.3. Type a different word that starts with a different letter into the second cell down the first column and press enter.4. Type the first letter of either word previously entered into the column and Excel will offer to automatically complete the entry to match the previously entered cell. Press 'Enter' to accept the entry or keep typing to make...
How to Merge Cells in Excel
1. Start Microsoft Excel, and open the spreadsheet that contains the multiple cells you would like to merge into one cell. If you like, you can just start a new spreadsheet to perform the task of merging cells.2. Select the cells that you would like to merge by clicking on the first cell with your mouse, holding down your left mouse button and dragging until all of the cells you want to merge are highlighted.3. Right-click to bring up the Excel menu and click on 'Format Cells...' to open the 'Format Cells' dialog box. In the 'Format Cells' dialog box you can change all of the formatting...
Subscribe to:
Posts (Atom)