FAQ & How To....For Microsoft Excel

  • <table border="0" cellpadding="0" cellspacing="0"><colgroup><col width="743" style="width: 557pt"></colgroup><tr><td>Microsoft Excel</td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr08/hey0414.mspx">How Can I Import a Fixed-Width Data File into Microsoft Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/mar08/hey0312.mspx">How Can I Sort a Spreadsheet By Cell Color?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb08/hey0226.mspx">How Can I Check the Value of a Specific Cell in a Bunch of Excel Spreadsheets?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb08/hey0220.mspx">How Can I Mark the First Occurrence of a Number in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb08/hey0207.mspx">How Can I Read Custom Summary Information Properties for an Excel File?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan08/hey0129.mspx">How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan08/hey0121.mspx">How Can I Import Multiple Worksheets into an Access Database?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan08/hey0118.mspx">How Can I Search For Values in an Excel Worksheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec07/hey1204.mspx">How Can I Cut a Row From One Excel Spreadsheet and Paste That Row Into Another Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov07/hey1101.mspx">How Can I Determine the Value of the Last Cell in an Excel Range?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct07/hey1022.mspx">How Can I Convert an Excel Serial Number to a Date and Then Back?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct07/hey1017.mspx">How Can I Insert New Rows Above the Last Row in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct07/hey1016.mspx">How Can I Copy Data from Excel to PowerPoint?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct07/hey1011.mspx">How Can I Retrieve Hyperlink Information From an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct07/hey1009.mspx">How Can I Insert Blank Rows (and Formulas) Into an Excel Worksheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept07/hey0912.mspx">How Can I Update and Then Break All the Links in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept07/hey0911.mspx">How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept07/hey0905.mspx">How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept07/hey0904.mspx">How Can I Add a Background Picture to an Excel Worksheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug07/hey0824.mspx">How Can I Replace Numeric Values in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug07/hey0821.mspx">How Can I Copy Data From One Spreadsheet to Another?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug07/hey0815.mspx">How Can I Replace Text in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jul07/hey0706.mspx">How Can I Set the Print Area in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun07/hey0622.mspx">How Can I Delete Specified Rows in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun07/hey0620.mspx">How Can I Color Every Other Row in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun07/hey0604.mspx">How Can I Copy Selected Columns From a CSV File to an Excel File?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/may07/hey0529.mspx">How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/may07/hey0525.mspx">How Can I Export an HTA Table to Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/may07/hey0501.mspx">How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0427.mspx">How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0425.mspx">How Can I Sort a Row in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0412.mspx">How Can I Remove the Password When Opening an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0404.mspx">How Can I Import an Excel Spreadsheet Into an Access Database?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0403.mspx">How Can I Save a Table in an Access Database as a Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb07/hey0220.mspx">How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb07/hey0219.mspx">How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb07/hey0212.mspx">How Can I Configure Excel to Autosave Every 5 Minutes?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb07/hey0208.mspx">How Can I Save an Excel Chart as a Picture?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan07/hey0131.mspx">How Can I Change the Font Color in Excel If a Specified Condition is Met?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan07/hey0125.mspx">How Can I Convert an Excel Spreadsheet to XML?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan07/hey0116.mspx">How Can I Set the Default File Path in Excel to a User’s Home Directory?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec06/hey1207.mspx">How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec06/hey1205.mspx">How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec06/hey1201.mspx">How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov06/hey1115.mspx">How Can I Add a Total Row to an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov06/hey1108.mspx">How Can I Create a Custom Date Format in Microsoft Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov06/hey1101.mspx">How Can I Keep the Screen From Updating While Running an Excel Script?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct06/hey1030.mspx">How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept06/hey0927.mspx">How Can I Determine the Background Color of a Spreadsheet Cell?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept06/hey0921.mspx">How Can I Make the First Character in a Cell Uppercase and All the Other Characters Lowercase?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept06/hey0918.mspx">How Can I Copy a Worksheet to a New Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept06/hey0908.mspx">How Can I Use Windows PowerShell to Automate Microsoft Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jul06/hey0720.mspx">How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jul06/hey0713.mspx">How Can I Add a COUNTIF Formula to an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun06/hey0626.mspx">How Can I Copy All the Comments From an Excel Worksheet to a Word Document?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/may06/hey0526.mspx">How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/may06/hey0518.mspx">How Can I Create a New Excel Spreadsheet at Midnight Each Night?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr06/hey0424.mspx">How Can I Select a Column of Data in Excel and Then Paste that Data into a Text File?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr06/hey0407.mspx">How Can I Convert a Number to a Date in Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr06/hey0406.mspx">How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/mar06/hey0307.mspx">How Can I Save an Excel Spreadsheet, and Then Save a Copy as HTML?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb06/hey0223.mspx">How Can I Format an Excel Spreadsheet So It Retains Leading Zeroes?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb06/hey0215.mspx">How Can I Determine the Last Row in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb06/hey0202.mspx">How Can I Remove All the Formatting from an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec05/hey1221.mspx">How Can I Change the Footer in an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/dec05/hey1215.mspx">How Can I Add Additional Worksheets to an Excel Workbook?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov05/hey1122.mspx">How Can I Sort Worksheets in a Workbook?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov05/hey1117.mspx">How Can I Import a Fixed-Width File into Microsoft Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov05/hey1104.mspx">How Can I Add a Hyperlink to an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct05/hey1012.mspx">How Can I Build an Array from a Column of Data in Excel?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept05/hey0920.mspx">How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept05/hey0912.mspx">How Can I Center Text in an Excel Cell?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun05/hey0629.mspx">How Can I Change the Background Color of a Cell Depending on the Date?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun05/hey0616.mspx">How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/may05/hey0531.mspx">How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr05/hey0427.mspx">How Can I Tell if an Excel Workbook is Open and, If It Isn’t, Open It?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr05/hey0411.mspx">How Can I Insert a Column into a Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/mar05/hey0322.mspx">How Can I Save a Single Excel Worksheet to a CSV File?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb05/hey0207.mspx">How Can I Password-Protect an Excel Spreadsheet?</a></td></tr><tr><td><a href="http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan05/hey0131.mspx">How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?</a></td></tr></table>