1. Log on to your computer and open Microsoft Excel 2003. Open a new or existing spreadsheet.2. Click the 'Format' menu and choose 'Cells.' Highlight the 'Date' option.3. Click the date format you want to use and click 'OK.' Enter a date in the cell to make sure it displays proper...
Browse » Home » Archives for March 2011
Monday, March 28, 2011
How to Convert Excel 2003 AutoFormat PivotTables to Excel 2007
1. Open Excel 2007.2. Click 'File,' 'Open.' Double-click the Excel 2003 workbook that contains the PivotTable. The workbook opens in Compatibility Mode.3. Click the Microsoft Office Button in the upper-left. Click 'Convert.' Click 'OK' to confirm.4. Click 'Yes' and the newly converted workbook will open and is ready to use.5. Click 'File,' 'Save' to confirm the new settin...
How to Write Sideways in Excel
1. Open Excel to a blank spreadsheet or open an existing spreadsheet.2. Click a cell you want to add text to. Click the 'Home' tab on the ribbon if it is not already open. Click the 'Text Orientation' button in the Alignment group. The button has no name but shows the letters 'ab' with an arrow underneath pointing diagonally.3. Select the type of rotation you want. You can select 'Vertical text' to have letters appear vertically one at a time in your cell or select 'Rotate up' or 'Rotate down' to face your text left or right.4. Type the text as you would normally. Press 'Enter' to see...
How to Print Head Rows on Each Page in Excel
1. Click 'Insert.'2. Select 'Header and Footer.'3. Click on the left, center, or right header, depending on which one you want to use.4. Type in your header.5. Print your spreadsheet and the header will display on every pa...
Sunday, March 27, 2011
How to Insert Time Into an Excel Spreadsheet
Static Time1. Select the cell where you wish to enter the time.2. Press 'Ctrl' 'Shift' ';'.3. Click the 'Format' menu and select the 'Cells' option.4. Click the 'Numbers' tab.5. Select 'Time' from the drop-down list and select your preferred format in the second column. You can also create a custom display format. When you're finished, click 'OK.'Dynamic Time6. Select a cell in your spreadsheet and type '=NOW()' into the cell.7. Press 'Enter.' The time and date are displayed in the default format.8. Change the format by following steps 3 to 5 in Section...
How to Add a Column Number in Microsoft Excel 2003
1. Choose a cell on your spreadsheet to display the result of your formula.2. Click the 'Insert Formula' button next to the formula bar.3. Select 'Lookup and Reference' from the drop-down list of function categories.4. Select 'COLUMN' from the list of functions and click 'OK'.5. Provide a reference for the 'COLUMN' formula to use. If you want to use the cell you selected in Step 1, do not enter a reference; if you want to use a different cell, enter that cell's coordinates in the reference box.6. Click the 'OK' button. Your cell will now display the numerical value of the column...
How to Calculate Linear Regression Using Excel
1. Type these data pairs starting in cell c3. For this and the remaining steps, press the 'Tab' key where a comma is shown. These numbers are data pairs collected from a hypothetical science experiment. In this experiment, assume there's the possibility of a linear relationship between 'x,' the first column of numbers, and 'y,' the second column.X, Y1, 5.22, 7.83, 10.74, 13.95, 16.52. Type these additional three columns, starting with the first cell to the right of the cell containing 'y.' These columns are factors in the calculations for the slope, y-intercept and R values of linear equations...
Saturday, March 26, 2011
How to Use Excel to Calculate a Confidence Interval
1. Enter the alpha value in cell A1. The alpha value equals 1 minus the confidence level. For example, if your confidence level equals 96 percent, you would enter 0.04 in cell A1.2. Enter the standard deviation in cell A2. For example, if your standard deviation equals 1.1, enter '1.1' in cell A2.3. Enter the sample size in cell A3. For example, if your sample size equals 3,000, enter '3,000' in cell A3.4. Enter 'CONFIDENCE(A1,A2,A3)' in cell A4 and Excel will display the confidence interval. In this example, Excel will display '0.041245769' meaning your confidence interval equals plus...
How to Get Rid of Gridlines in Microsoft Excel 2007
Remove Gridlines from Excel1. Open an existing or new Microsoft Excel 2007 spreadsheet.2. Right-click with your mouse on the 'Tools' menu, located on the top toolbar.3. Locate and right-click on 'Options.'4. Select the 'View' tab.5. In the 'Windows Options' section, located in at the bottom of the pop-up window, right click in the check box next to: 'Gridlines.' Click 'OK' to save your changes.Remove Gridlines from Excel Print Job6. Open an existing or new Microsoft Excel 2007 spreadsheet.7. Right-click on the 'File' menu, located on the top toolbar.8. Locate and right-click on...
How to Insert a Grid in Microsoft Excel 2003
1. Click 'Insert' in the top toolbar of Microsoft Excel 2003. It's the third option after 'File.'2. Select 'Picture' and then 'Clip Art' from the drop-down menu.3. Type 'Grid' in the box labeled 'Search.' This box is located on top of the 'Clip Art' box that opened on the left-hand side of the screen.4. Press the 'Go' box to begin searching for the different types of grids available to insert into your Microsoft Excel 2003 document.5. Double-click the box of the grid you want to insert into the document. This will place the grid into Excel automatically.6. Hold down the 'Ctrl' and...
How to Make Posters in Excel
1. Open Excel. Click on the 'File' menu at the top of the screen once it opens. Select the 'Page Setup' command.' Choose the 'Page' tab.2. Adjust the page scaling to '200%' and click on the radio button next to 'Landscape' for the page orientation. Click on the 'Margins' tab.3. Click into the text boxes for the top, bottom, left, and right and type '0.5'. Click into the text boxes under 'Header' and 'Footer' and type '0.' This will adjust the margins of each sheet of paper.4. Click the 'Zoom' tab and set the zoom rate to '40 percent.' Click on the 'OK' button.5. Click on cell...
Friday, March 25, 2011
How Do I Change Margins on an Excel Spreadsheet?
Change Margins by Dimension1. Open Microsoft Excel.2. Click the 'File' button on the menu and then click the 'Page Setup' button.3. Click the 'Margins' tab and then enter the size you want the margins to have.Change Margins Graphically4. Open Microsoft Excel.5. Click the 'File' button on the menu and select the 'Print Preview' option.6. Select the 'Margins' button and then drag the margin handles to change their si...
How to Delete an Excel 2007 Button Face ID
1. Open the Microsoft Excel 2007 application on your computer and then click the 'Microsoft Office' button. Click the 'Open' option.2. Select the Excel 2007 spreadsheet file that contains the button face ID you want to remove. Click the 'Open' button again.3. Click the 'Developer' tab and then click the 'Macros' option from the 'Code' group. The 'Macros in' list will then appear,4. Click the workbook containing the macro for the button face ID. Select the name of the macro for the button face ID in the 'Macro name' box.5. Click the 'Delete' button and then the macro and button face ID...
How to Insert Check Boxes
Inserting a Check Box in Word (2010)1. Display word's developer tab. Click on the 'Office' button, then 'Word Options,' followed by 'Customize Ribbon.' Check the 'Developer' box if it is not already selected. Click 'OK.' The developer tab should appear.2. Click on the developer tab. Find the controls group. Click on 'Legacy Tools.' Click on 'Check Box Form Field.' The box appears on your document.3. Move or resize the check box as needed, using the cursor.4. Click 'Restrict Editing' in the 'Protect' group on the developer tab. a 'Restrict Formatting and Editing' box should appear. Check...
Thursday, March 24, 2011
How to Make a Form in Excel
1. Turn on your computer and open the Excel program. A blank workbook will automatically open at start-up.2. Create your form the way you'd like it to appear, including entering formulas.3. Format the form using borders, shading, color and text formatting until you are satisfied with the appearance.4. Unlock the cells where you'd like users to be able to enter data. To do so, select these cells, then click 'Format/Cells/Protection' and make sure the 'Locked' feature is not checked.5. Select your print area. To make the process even simpler for users, select the area of the spreadsheet...
Wednesday, March 23, 2011
How to Make Gridlines Print in Microsoft Excel 2007 Spreadsheets
1. Select the 'Page Layout' tab. It is located on the 'Ribbon,' the group of icons above the work area in Excel.2. Put a check in the 'Print' box. Once on the Page Layout Tab, look toward the right side and you will see a group called 'Gridlines.' This will cause the gridlines to show when you print your spreadsheet.3. If you change your mind and would like to have the gridlines hidden on print jobs again, simply remove the check from the 'Print' b...
How to Create a MS Excel Skin
1. In MS Excel, select 'Format' from the Menu Bar.2. Select 'Sheet.'3. Select 'Background.'4. Click on the picture you would like to use as a skin.5. Click on the 'Insert' butt...
How to Put a Decimal Place in Excel 2003
1. Open Excel 2003 and select the 'File' drop down menu. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.2. Review the spreadsheets in the workbook and locate a workbook that needs decimal places in the data. Highlight the range the contains data that needs a decimal place.3. Select the 'Format' drop down menu and select 'Cells.' Click the 'Number' tab. Select the 'Number' option in the left 'Category' section. Change the decimal places to '1.' Click 'Ok.' The decimal places are added to the Excel 2003 spreadshe...
How to Use Excel's FREQUENCY Function
1. Remember the formula breaks down to the following: FREQUENCY(data_array,bins_array). Data is the set of values for which you will compute the frequencies. If you don't enter any data in the cell, you'll receive zeros in return. Bin is how you want the data broken down, or the ranges into which you want the data to fall.2. Note that the FREQUENCY function will always give you one more frequency than data entered. For example, if you're a teacher and you enter in the test scores of 20 students, then you'll receive 21 frequency values.3. Set up your worksheet to contain the data and the...
How to Use Excel to Generate Random Samples
1. Determine a range of numerical data in an Excel worksheet from which you want to generate a random sample. For example, generate a random sample from the numbers 1 through 10 listed in the first column in cells A1 through A10.2. Click the 'Data' tab at the top of Excel and click 'Data Analysis' in the 'Analysis' group.3. Click 'Sampling' in the 'Analysis Tools' list, then click 'OK.' This brings up a small window called 'Sampling.'4. Click the button with the red arrow next to box called 'Input Range' in the 'Input' section. This shrinks the sampling window to a single row in which...
Tuesday, March 22, 2011
How to Add a Drop Down Calendar in Excel 2007
1. Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). If it isn't, then click the 'Office' button at the top left, then choose 'Excel Options'. This will bring up a pop up window. Put a check mark in the 'Show Developer Tab in the Ribbon' option, then click 'OK'.2. Click on the 'Developer' tab. Click on the small arrow below the 'Insert' tab and choose 'ActiveX Controls'. Click the last icon in the list ('More controls').3. Choose 'Calendar Control' and press 'OK'.4. Click on a cell in your worksheet where you would like to place the calendar. Click...
How to Create a Template for Excel 2003
1. Open Excel 2003 and locate a workbook that you want to base you template on. Click 'File' and 'Open' on the menu bar. Search your computer for the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Review the workbook and decide what information will remain in the workbook after it becomes a template. Information that would remain would be date formulas, contact information, company logo and other information relevant to your project. Remove any information that refers to a specific customer or vendor if this workbook will be used for all of customers...
How to Use the Option Buttons in Excel
1. Open Excel. Click 'File' and 'New' in the menu bar. Select 'Blank Workbook' from the pane on the right side of the Excel window.2. Turn on the Forms toolbar. Right-click in the gray area of any toolbar. Select 'Forms' from the displayed list.3. Add a group box. Select 'Group Box' from the 'Forms' toolbar. Click and drag in the spreadsheet with the mouse to create a group box of the desired size.4. Rename Group Box 1 by highlighting the text and typing an appropriate name.5. Create the option button. Click on 'Option Button' in the 'Forms' toolbar. Click in the desired area of the...
How to Export OpenOffice Calc to XML
1. Open your Calc spreadsheet in OpenOffice.org's Calc program.2. Click 'File' in the top menu and select 'Save As'. Alternatively, hold the 'Ctrl' and 'Shift' keys down and press 'S'.3. Click the drop-down menu next to 'Save as type' and select 'Microsoft Excel 2003 XML (xml)'.4. Enter a new name for your spreadsheet if one is not automatically chosen. If you previously saved this document the original file name is filled in. You can use this file name without overwriting the original file, since the extension will be different.5. Click 'Save' to export your Calc spreadsheet in XML...
Monday, March 21, 2011
How to Make a Thermometer Chart in Microsoft Excel
1. Open a blank worksheet in Excel. Enter headings for two columns of data, such as 'Month' and 'Total Clients' in cells A1 and B1. Enter the appropriate data into the column cells. The data should be building toward a goal.2. Enter the goal number at the bottom of the column and enter the actual number reached in the cell beneath the goal amount, which will be the number in the last cell.3. Skip a cell below the totals, and enter a formula to determine the percentage reached in the next cell. In the Formula Bar, use the formula total amount/goal amount. For example, the formula could be...
How to Break Hours Minutes Down into Increments for Excel
1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and type in the time that you want to break down. Enter the time as 'hh:mm.'2. Click on cell 'B1' and enter the following formula into the cell:=ROUND(A1*(1440/x),0)/(1440/x)Change each 'x' to be a number equal to the number of minutes in your desired time increments. If your increments are in seconds, change both instances of '1440' to '86400' and enter the number of seconds in each increment for 'x.' Press 'Enter' to complete the formula and a small number will appear in the cell.3. Right-click cell 'B1 and choose 'Format...
How to Restore One Deleted Excel Worksheet
1. Click the 'Office Button' and select 'Save As' from the drop-down menu. Select Excel Workbook from the 'Save As' menu and type a new name for your workbook in the 'File Name' field. Press 'Save.' You will now have two workbooks---your original workbook before you made any changes with the 'deleted' worksheet intact, and the newly saved workbook with all of your changes. Only your newly created workbook will remain open.2. Open your original workbook. You should now have both workbooks open.3. Right click on the name tab of the 'deleted' worksheet in your original workbook and click 'Move...
How to Learn Excel 2003
1. Learn Excel directly from the maker using the resources available at Microsoft Office Online. This website offers courses ranging from 30 to 50 minutes that walk you through the basics of how to use Excel, so you can be on your way in just a couple of hours.2. Check the website of your local community or technical college for introductory classes on Excel. These classes may be free or discounted compared to private university tuition. If you are a senior citizen you may be eligible for a discount on tuition. Most classes will focus on newer versions of Excel, but you can ask the instructor...
How to Use Microsoft Excel 2003 as a Normal User
1. Open Microsoft Excel 2003. A blank spreadsheet appears. At the top, the toolbar lists the functions available to you. Use the arrow keys on your keyboard to move one cell at a time throughout your spreadsheet. You can also click into any cell.2. Enter information by typing it and pressing the 'Enter' key. For example, to keep track of grades for three students, enter the first name in cell A2. Enter the second name in cell A3. Enter the third name in cell A3. Enter 'Test 1' in cell B1. Enter 'Test 2' in cell C1. Then, enter the grades for the students.3. Format cells to make your spreadsheet...
How to Have Multiple Users Use One Sheet in Excel
Sharing in Excel 97/2000/XP/20031. Create or open the workbook you would like to share.2. Under the Tools menu, select 'Share Workbook.'3. The 'Share Workbook' window will appear. The 'Editing' tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.4. The 'Advanced' tab allows you to adjust the options for sharing, such as how long changes are tracked, how often they are updated and what happens when information conflicts. Select the options you wish to implement and click...
How to Select Cells as the Print Area in Excel 2003
1. Click on the first upper-left cell you want to print.2. Press 'Shift' and the arrow keys until you cover the entire area you want to print.3. Click 'File' followed by 'Print,' 'Selection' and 'Print' aga...
Sunday, March 20, 2011
How to Add Comments to a Worksheet in Excel 2003
1. Open your Excel worksheet.2. Select the cell to which you wish to add a comment. Click on the cell with your mouse's left button.3. Select 'Insert' from the top menu bar and in the dropdown menu choose 'Comment.'4. A text box will appear right after you click 'Comment.'5. Type your comment into the text box.6. When you've finished typing, click anywhere outside of the text box. This will save your chang...
How to Convert Lotus to Excel 2003
1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'2. Click 'File,' then 'Open.' Click the file type drop-down menu and select 'All Files and Folders.'3. Locate your Lotus 1-2-3 file, then select it and click 'Open.'4. Click 'File,' then 'Save As.'5. Click the file type drop-down menu and select 'Microsoft Excel Workbook.' Choose a name for your converted file and click 'Save.' You have now converted Lotus to Excel 20...
How to Align a Worksheet Horizontally Vertically in Excel 2003
1. Open the Excel file that contains the worksheet that you want to align horizontally and vertically. Click the appropriate worksheet.2. Click the 'File' menu and select the 'Page Setup' option, which opens a separate window. Click the 'Margins' tab on the Page Setup window.3. Click the 'Horizontally' and 'Vertically' check boxes under the Center on Page secti...
Saturday, March 19, 2011
How to Create a Line Graph in MS Excel
Create Graph1. Open Excel and enter your information onto a worksheet. For a line graph, you can arrange the data in rows or columns. For example, if you are showing the monthly average temperatures for a location, you could head each column with the month and each row could represent a different year.2. Click on the first cell you want included in your line graph and while holding down the mouse button, drag your mouse to highlight the rest of the data you want on your graph.3. Click on the 'Insert' tab and select 'Line' from the 'Chart' options. The picture shows a line graph. Choose and...
How to Make a Gradebook in Excel
1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and enter in 'Name,' as this is the column where the student's names will go. Click on cell 'B1' and enter 'Points,' as this is where the student's points will be totaled. Click on cell 'C1' and enter 'Percentage,' as this is where the student's grade percentage will go.2. Select cell 'D1,' and then progressing down the rest of the spreadsheet's top row, enter the names of the quizzes, homework assignments, tests, projects and anything else the students will be graded on. If you aren't sure how many of these you will have,...
How to Create a List Box in Microsoft Excel
1. Double-click the Excel spreadsheet you want to alter. This loads the spreadsheet and the Excel software at the same time.2. Click a cell in which you want the list box to display. Click the 'Data' menu item in the main toolbar. In Excel 2007, click the 'Data' ribbon tab.3. Click the 'Validation' menu option. In Excel 2007, click the 'Validation' button and select 'Data Validation' again. This opens a new window where you set the list box settings.4. Click 'List' in the first window. This sets the type of drop down box for the cell. When the drop down type is selected, a text box is...
Friday, March 18, 2011
How to Perform Factor Analysis
Performing a Factor Analysis1. Generate a correlation matrix on the data set. A correlation matrix is a table of correlation coefficients. A correlation coefficient is the quantifying unit of correlation. This number expresses the direction and strength of a linear relationship measured between two random variables.2. Establish baselines for desired factors (compiled variables). For example, if the data collection instrument is a survey and responses are measured from 1 -- Least Desirable Outcome to 10 -- Most Desirable Outcome, values of 8, 9 and 10 may be examined and the corresponding...
How to Change an Excel Spreadsheet Into an Interactive PDF
1. Open Adobe Acrobat on your computer. In the 'Getting Started' window, click 'Convert an Existing Document' to launch the 'Create New Forms' wizard. Alternately, you can select 'Create New Form' from the 'File' menu or the 'Forms' menu. In Acrobat 9, click 'Forms' and select 'Start Form Wizard.'2. Select 'An Existing Electronic Document.'3. Follow the on-screen instruction to upload the data from your spreadsheet file. The wizard will be slightly different depending on the version of Acrobat you are using. Make sure your spreadsheet is saved in a place where you can access it.4. Proceed...
Thursday, March 17, 2011
How to Create an Organization Chart From Excel
1. Open a new document in Microsoft Excel 2007 and click on the 'Insert' tab.2. Click on 'SmartArt'. In the 'Choose a SmartArt Graphic' window, click on 'Hierarchy'.3. Select the first chart, which is the Organization Chart. Click OK.4. Begin typing the name of the first person at the highest level in the organization such as the CEO in the 'Type your text here' window. Click on the indented text areas to add names for the rest of the employees. You can add additional boxes by pressing Enter in the 'Type your text here' window at the desired positi...
How to Include Indian Currency as Part of the Currency Symbols in Excel
1. Open a Web browser, and navigate to the download page for the Windows Rupee symbol update (support.microsoft.com). Click the download link next to the version of Windows that you have installed.2. Click the 'Continue' button on the next page. Click 'Continue' again, and save the file 'GenuineCheck.exe' to the desktop. Run the tool, and copy the code displayed into the field under 'Enter your validation code' on the Microsoft Genuine Windows Validation page. Click 'Validate.'3. Click the 'Download' button, and save the Rupee symbol update to the desktop. Double-click the update file --...
How to Make Everything Uppercase in Excel
1. Open the Excel worksheet.2. Press Alt and F11 to bring up the Excel 2010 VBA console. Once the console opens, find the name of your workbook on the list on the left side of the screen. Right-click the workbook name, move your mouse over 'Insert' and select 'Module.' Double-click the module that appears.3. Click anywhere in the blank white space on the right side of the VBA console. Type in the following: 'Sub UpperCaseConvert()' and press Enter. VBA will automatically insert the 'End sub' command at the bottom of the code.4. Type 'Dim x As Range' into the line directly beneath the...
How to Make a Checklist in Microsoft Word 2003
1. Create your list entries. Create the desired entries of the list and click the “Return” key after making each individual entry.2. Highlight the entries. Left-click and hold the mouse button in as you drag the cursor over all of the entries that you just created. Then release the mouse button and the entries will remain highlighted.3. Create the checklist. On the font formatting toolbar, found on the command bar, you will see several icons that allow for font formatting, billet points and list creation. The list creation icon appears as the numbers 1 through 3 and each number has a line...
Wednesday, March 16, 2011
How to Turn off Gridlines in Excel
1. Launch Excel by clicking on the 'Excel' shortcut in your Windows Start Menu.2. Open the worksheet for which you want to disable gridlines by clicking on the 'Excel' icon and selecting the 'Open' command.3. Click on the 'View' tab and de-select the 'Gridlines' check box under the 'Show/Hide' catego...
Tuesday, March 15, 2011
How to Go to Precedent Worksheets in Excel
Enable the Display Options1. Open the saved Excel worksheet.2. Click the 'File' tab on the command ribbon. A list of commands will appear.3. Click 'Options.' The 'Excel Options' dialog box will open.4. Click the 'Advanced' button on the left pane. The 'Advanced' pane will appear.5. Scroll down the right pane to the 'Display' section.6. Select the named workbook in the 'Display Options for This Workbook' text box.7. Select the radio button for 'All' in the 'For Objects, Show' option.8. Open another workbook if it contains the formula's reference cells. An open workbook makes the...
Monday, March 14, 2011
How to Use VBA to Import Data From Excel Into Access
1. Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.2. Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel Object Library.'3. Start by typing the...
How to Open Excel 2007 Without a Blank Document
1. Click on the 'Microsoft Office' button.2. Click on 'Excel Options.' The Excel Options dialog box will open.3. Click on the 'Advance' tab, then scroll down to 'General.'4. Type the name of your file location in the 'At startup, open all files in:' text box. For example, type 'C://MyDocuments/myfile.xls.'5. Click on the 'OK' button. The next time you open Excel, the selected files will open automatical...
How to Use Calendar Control in VBA Excel
1. Start Microsoft Office Excel, select the 'Developer' tab then click 'Visual Basic.' Click the 'Insert' menu and select 'UserForm.'2. Right-click the 'Toolbox' menu and select 'Additional Controls...'. Check the box next to 'Calendar Control 12.0' then click 'OK.'3. Click the calendar control and add it to 'UserForm1.' Click the 'CommandButton' control and add one to your 'UserForm1.' Double-click the 'CommandButton1' to open Microsoft Visual Basic.4. Copy and paste the code below inside the 'CommandButton1_Click()' subroutine.Dim dataString As StringdataString = Calendar1.ValueActiveCell...
Sunday, March 13, 2011
How to Find Hidden Columns in Excel 2007
1. Inspect the column headers at the top of the Excel 2007 spreadsheet. The headers are gray and are labeled with letters in consecutive alphabetical order. Note which letters are missing from the headers. These missing letters indicate which columns are hidden.2. Reveal single or consecutively hidden columns by clicking on the two columns that would be on either side of the hidden columns. For example, if column 'B' is missing (hidden), you will click on columns 'A' and 'C' to select them. To continue that example, if columns 'B' through 'F' are hidden, you will click on columns 'A' and 'G'...
How to Highlight Changes in Microsoft Excel 2003
1. Access the highlight menu. To access this menu, scroll to the “Tools” tab and select “Track Changes.”2. Open the Highlight Changes Options menu. Under the submenu that opens scroll to “Highlight Changes” and left-click to access the 'Highlight Changes' menu. Make sure to check the box labeled “Track Changes While Editing.”3. Set up the “When” attributes. By checking this box, you can access a dropdown menu where you can choose from the following: All (which will track changes by everybody), Since I Last Saved (which will track changes from your last save), Not Yet Reviewed (which will...
Saturday, March 12, 2011
How to Find the Author of an Excel Document in 2007
1. Open the Excel document in Microsoft Excel 2007.2. Click the top left 'Office' button, select 'Prepare' and click 'Properties.'3. Look at the top left 'Author' field of the 'Document Properties' panel that appears just above your spreadsheet. This field lists the author of the Excel docume...
How to Insert a Cell Drop
Microsoft Excel 20031. Open the Microsoft Excel 2003 application on your computer. Enter the data you want for your drop-down box into a single column of your spreadsheet.2. Click on the cell where you want the drop-down list to begin so that it’s selected. Click on the “Data” option from the top toolbar menu.3. Click on the “Validation” option and then click on the “Settings” tab. Click on the “List” option from the “Allow” box.4. Enter the reference for all of the cells to be used in the drop-down list into the “Source” box. Click on the box next to the “In-cell drop-down” field so that...
Friday, March 11, 2011
How to Create Dynamic Charts in Excel Using Data Filters
1. Organize the source data in your spreadsheet.2. Create the type of chart specific to your data needs using the Chart Wizard tool.3. Insert data filters to the source data by selecting 'Menu' then 'Data.' Next choose 'Filter' and then 'Auto Filter.' In Microsoft Excel 2007, use the home ribbon and then select 'Filter and Sort Button' followed by 'Filter.'4. Apply the data filter to select the type of data you wish to use in the chart. The chart will automatically change depending upon how the data is filter...
How to Add Add
1. Open Excel and click the Office button. You can open, save or print a document and view the default settings for Excel using this menu.2. Click the 'Excel Options' button located at the bottom of the menu that opens.3. Select 'Add-Ins' located in the options list. You can view and manage your add-ins here.4. Click the arrow next to 'Manage' and select 'COM Add-Ins' from the drop-down list that opens and click 'Go.' A box will open that shows the add-ins that are available for you to add or remove from Excel.5. Select an add-in you want to use in Excel and click 'Add.' The add-in...
How to Do Add
1. Open Microsoft Excel, and click on the 'Office' button.2. Click on 'Excel Options' located at the bottom right corner of the Office menu window.3. Select 'Add-Ins' from the vertical navigation bar on the left of the 'Excel Options' window.4. Check the boxes next to the add-in programs you would like to download, and then click 'OK.'5. Follow the installation prompts to install the add-ins, and then click on 'Add-Ins' located in the toolbar at the top of the Office Excel page to load and use your add-in programs; you can also access them through the data, formula and add-in ta...
How to Create High Resolution TIFF Files From Excel Files
1. Create your file in Microsoft Excel. This can be anything from an invoice to a chart to a simple listing of data.2. Select the area of your Excel spreadsheet that you want to convert to a TIFF file. Go to the 'Page Layout' menu then click 'Print Area' and 'Set Print Area' (this option may appear under 'File' menu in some older versions of Excel).3. Print the file to a standard postscript printer (download a free file at Adobe.com). Name the postscript file and type in '.ps' without the quotation marks as the file extension.4. Open the .ps file in Adobe Photoshop. A dialog box will open,...
How to Make an X Axis in Excel 2007
1. Open the spreadsheet with the data for which you wish to create a graph. Place all the X values in one column and the Y values in a second column. Each row should contain the matching values for both axes.2. Click 'Insert' on the Menu bar and go to 'Chart.' Pick your desired picture and input the description of the graph in the box provided.3. Move to Step 2 of the Chart Wizard to arrange the Chart Source Data. Highlight the columns and their respective headings and click 'Enter.' Choose the 'Series: in columns' button.4. Go to Series tab and fill out the X and Y value fields. Check...
How to Use a Letter to Represent a Value in Excel
1. Launch Microsoft Excel.2. In the Excel spreadsheet, type a letter in the column 'A' (for example, in the cell 'A1'). Type the value, which should be represented by the letter, in the same row in the column 'B' namely in the cell 'B1.'3. Repeat Step 2 to add to the spreadsheet other letters you wish to associate with values. Make sure to add one such 'letter-value' entry per row. In the example shown in the figure, the array 'letter-value' spans six rows from the cells 'A1' and 'B1' to 'A6' and 'B6.'4. In the Excel spreadsheet, select a cell in which you want to insert the value using...
Subscribe to:
Posts (Atom)