Home > Excel Help Portal > Formatting Excel

<<  (Page 2)  Previous              Next  (Page 4)  >>

Formatting Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to format Microsoft
Excel.

101. Help making better Excel graphs If you type titles directly into the Chart Options they will be static and unchanging, regardless of what happens to your data. You may wish to make a title update itself to include a variable element such as the current month name. Edit your chart and click on the existing chart title - then in... Keywords: Charts, Legend, SERIES, Data Table, Rank, Format, Patterns, Formulas, Printing, Links

 
102. How to Map Imported Files into Outlook Using Excel Microsoft Outlook 98 does not have the Field Mapping feature found in Microsoft Outlook 97. This article describes how to use Microsoft Excel as an interim step to conveniently map fields from another database into Outlook 98. This import... KB#189181. Keywords: Export, Format, Patterns, Files, Window

 
103. How to Simulate a Paused Visual Basic Procedure There is no built-in method for pausing a macro in Microsoft Excel. This article contains one method for stopping a macro for user input and then continuing when the user clicks a... KB#161535. Keywords: Borders, Format, Outline, Styles, VBA, Macro, Object, Toolbar, Web, Window

 
104. Making HTML web pages from Excel worksheets Excel contains a command to save an area of a worksheet in HTML format so that it can viewed through a web browser and incorporated in a website. The files created by this command are excessively large and contain limited formatting. Alternatively a macro can be used to create a web page which... Keywords: SERIES, SQL, XML, Borders, Colors, Fonts, Format, Styles, Arrays, Macro, VBA, Files, Text Files, HTML, Hyperlinks, Web

 
105. Fit Print to Page, and Adjustments to Layout Unless you select and area and print selection, limit with Print Area, or have hidden rows and/or columns you will print from cell A1 to your lastcell (Ctrl+End). Excel does not keep track of the used range very well though, so if you insert rows and then delete rows, Excel remembers how many rows... Keywords: Borders, Fonts, Format, Gridlines, Page Setup, Printing, Toolbar, Web, Comments

 
106. How to Programmatically Reset a Workbook to Default Styles The following Microsoft Visual Basic for Applications Sub procedure removes all styles in a Microsoft Excel workbook and then adds back the default styles you see in a new workbook. This macro may be helpful for removing extra styles added to... KB#247980. Keywords: Download, Format, Styles, Startup, VBA, Macro, Corrupted, Files, Templates, Web

 
107. How to Change the Font in a Cell Comment When you record a macro in which you change the font of a cell comment, and then subsequently rerun the macro, the font of the comment does not change as you... KB#173798. Keywords: AutoShapes, Colors, Fonts, Format, VBA, Macro, Toolbar, Web, Comments

 
108. How to Create a UserDefined Chart Format In Microsoft Excel, you can produce charts with a consistent look by creating a user-defined chart format. This article contains steps you can follow to create a sample chart, to use that sample chart as the basis for a user-defined chart format,... KB#142124. Keywords: Charts, AutoFormat

 
109. How to Programmatically Reset a Workbook to Default Styles The following Microsoft Visual Basic for Applications Sub procedure removes all styles in a Microsoft Excel workbook and then adds back the default styles you see in a new workbook. This macro may be helpful for removing extra styles added to... KB#247933. Keywords: Download, Format, Styles, Startup, VBA, Macro, Templates, Web

 
110. Combining Different Chart Types into a Single Chart See also Chart Axes and Axis Tricks and Dummy Series. -- Introduction to Combination Charts Excel offers a wide range of chart types: Line Charts, Column Charts, Area Charts, Bar Charts, Scatter Charts, and Pie Charts, to name but a few. You can even mix different types on a single chart by... Keywords: Add-In, Charts, Legend, SERIES, Whisker, Download, OLE, Colors, Format, Patterns, Errors, Links, Menu Command

 
111. How to Change the Font in a Cell Comment When you record a macro in which you change the font of a cell comment, and you then subsequently rerun the macro, the font of the comment does not change as you... KB#213680. Keywords: AutoShapes, Colors, Fonts, Format, VBA, Macro, Object, Web, Comments

 
112. Stats Page Using CASE and CALLER. Each button on my front sheet has been assigned to the macro “Directories”. Option Explicit Global dirName as String, LongName, LengName as... Keywords: SERIES, Colors, Format, Printing, VBA, Macro, Comments

 
113. Microsoft Excel 2000 Specifications This article explains the following Microsoft Excel 2000 specifications: Worksheet and workbook specifications Calculation specifications PivotTable report specifications This information is also covered in detail in Microsoft Excel Help.... KB#264626. Keywords: Solver, Sorting, Colors, Custom Number Formats, Styles, Arrays, Formulas, PivotTables, Toolbar, Scenarios, Column Width, Window

 
114. Merging Adjacent Cells Cheryl sent in this week's problem. Excel veterans will see this as basic, but it was a valuable tip to Cheryl. Since this is the first tip of the 1999-2000 season, we'll start with a basic one. Someone gave me an Excel spreadsheet. Area codes are in column F, and a 7 digit phone number is in... Keywords: Format, Symbol, Formulas, VBA, Web, LEFT, MID

 
115. Excel Quits When You Draw a Connector Line on a Chart If you draw a connector line on a Microsoft Excel 2002 chart that you are editing, Excel 2002 quits or stops... KB#821078. Keywords: Charts, Dates, Fonts, Format, File Name, Files, Registry, Web

 
116. How to use the Paste Options Buttons in Excel This step-by-step article describes the functionality of the Paste Options button in Microsoft Excel. The Paste Options button becomes available when you paste data into cells in Excel. The button appears just below the pasted selection. When... KB#291358. Keywords: AutoCorrect, Dates, Format, Errors, Formulas, Links, Smart Tag

 
117. Euro Currency Character Is Not Displayed Correctly The euro currency character is not displayed as expected on your worksheet. It appears as a vertical bar or a pipe character instead of the euro... KB#217124. Keywords: Ratio, Fonts, Format, Links, Registry, Web

 
118. Excel Stops After Specifying Conditional Format When you specify a conditional format that refers to a user-defined function, the Microsoft Excel screen may stop updating or may be redrawn incorrectly, or Microsoft Excel may stop... KB#156892. Keywords: Colors, Conditional Formating, VBA, Web

 
119. Produce Color Chart Option Explicit Public ColChoice As Variant, ThrdTier, RowPos As Integer Public BackCol, ForeColor, FirsTier, SecTier, f1STpACK, s2NDpACK, t3RDpACK, POS Public firstDec, secDec, thirdDec, DecChoice, CompleteY, QuoTe As... Keywords: Charts, Colors, Fonts, Arrays, Formulas, Links, Printing, VBA, Macro, HTML, Web

 
120. Visual Basic Procedure to Change the Standard Font This article includes a sample Microsoft Visual Basic for Applications procedure that you can use to change the standard font in Microsoft Excel. This procedure may be useful if you are creating a custom program and you want to be able... KB#213469. Keywords: Fonts, Format, Styles, VBA, Macro, Web, Window

 
121. Exporting Excel Data in Special Formats You can use a VBA procedure to export data in comma delimited format. Or, change the delimiting character to export the data separated by semicolons,... Keywords: Export, Format, Styles, Errors, Printing, VBA, Iteration, Macro, Menu Command, Text Files

 
122. How to Use the "Insert Options" Button in Excel 2002 This article explains the functionality of the Insert Options button in the Excel 2002 user interface... KB#291363. Keywords: AutoCorrect, Format, Errors, Smart Tag

 
123. How to change Default Colors in Excel 2000 This step-by-step article describes how to change the default colors in Microsoft Excel for items such as the worksheet tabs, sheet background, and worksheet tab fonts. Because Excel uses Microsoft Windows colors for several of its elements, you... KB#264582. Keywords: Borders, Colors, Fonts, Format, Gridlines, Comments, Window

 
124. Protection, Worksheet Keywords: Borders, Colors, Format, Styles, Errors, Formulas, Password, VBA, Macro, Web, Comments, Validation

 
125. Unlocked Cells Not Underlined with Protection Enabled In Microsoft Excel versions earlier than 5.0, while worksheet protection is enabled and gridlines are turned off, unlocked cells appear underlined. This underline identifies the cells that you can edit. Although this feature is not available... KB#213661. Keywords: Borders, Format, Gridlines, Password, Macro, VBA, Web

 
126. Errors After Copying Worksheet with Auditing Arrows In Microsoft Excel, the following problems may occur: When you delete a worksheet, you receive the following error message: This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.... KB#211439. Keywords: Format, Errors, Error Message, File Name, Toolbar, Auditing

 
127. Macro to Change the Date/Time Format in a Header/Footer In Microsoft Excel, when you use the date code, &[Date], to insert the date in the header or footer of a document, the date appears in the default MM/DD/YY format. The time code, &[Time], appears in the default H:MM AM/PM format. These date... KB#213742. Keywords: Custom Number Formats, Printing, VBA, Macro, Setup, Web

 
128. Labels on XAxis of XY (Scatter) Chart Distorted When Rotated 90 Degrees In an xy (scatter) chart that uses x-axis labels, the x-axis labels may be distorted, truncated, or... KB#236298. Keywords: Charts, Plot, Text Box, Fonts, Format, Formulas, Object

 
129. How to Use the SelectionChange Event to Make the Active Row Bold When you work in a Microsoft Excel worksheet, you may want to make the active item bold so that it is easier to read. This article contains a sample Microsoft Visual Basic for Applications macro that makes the font of the current row... KB#213193. Keywords: Fonts, Styles, VBA, Macro, Object, Web, Window

 
130. How to Programmatically Reset a Workbook to Default Styles The following Microsoft Visual Basic for Applications Sub procedure removes all styles in a Microsoft Excel workbook and then adds back the default styles you see in a new workbook. This macro may be helpful for removing extra styles added to... KB#291321. Keywords: Styles, Startup, VBA, Macro, Templates, Web

 
131. How to Lock Individual Cells in a Worksheet This article describes how to lock individual cells in a Microsoft Excel worksheet. The procedure to use depends on whether you want the majority of the cells on the worksheet to remain locked or unlocked. NOTE : If you lock a cell and protect... KB#214081. Keywords: Format, Password

 
132. Excel FAQ - Dates and Times 25, 50 47, etc... the result I would like is 1:10, 1:50: 2:03 Since XL stores times as fractions of days, in order to convert integers into times you need to divide the sum by (24*60*60) or 86,400 1 is a day; 24 hours. So one hour is 1/24. =A1*B1*24 will bring the desired result. Format result... Keywords: SERIES, Dates, Months, Years, Custom Number Formats, Web

 
133. How to Sum a Range of Cells Based on a Number Format This article includes a sample Microsoft Visual Basic for Applications custom function that sums the values in a range of cells that are formatted with a specific custom number... KB#213728. Keywords: Custom Number Formats, VBA, Web

 
134. Sample Visual Basic Code to Create Color Index Table The sample macro in the More Information section of this article prints a sample of each color in one column, and then prints the index number for that color in the adjacent column. This type of list is valuable for determining how a certain... KB#213801. Keywords: Colors, ColorIndex, Format, Patterns, Errors, Printing, VBA, Macro, Web

 
135. An example of a Cascading Style Sheet CSS You may hear of references to style sheets (CSS) which can be used to determine the effects of HTML commands such as headings, paragraphs and tables. They are not complicated and there is plenty of help available on the internet. Nevertheless, producing a working example can be time consuming and... Keywords: SQL, Borders, Colors, Format, Styles, Errors, Links, Class, Save A File, HTML, Hyperlinks, Web

 
136. How to Call a Macro Repeatedly on a Fixed Time Interval You can call a macro repeatedly at a set time interval using the OnTime method and the Call... KB#151503. Keywords: Format, VBA, Macro, Toolbar, Web

 
137. Printing using macros Expanding the possibilites with Macros This page contains some VBA macros. If you need assistance to install or to use a macro please refer refer to my GetFormula... Keywords: Errors, Formulas, Printing, VBA, Macro, Setup, Web, Comments, Window

 
138. How to Display Only Certain States/Nations in Microsoft Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to limit the states or countries shown on a map to a given list. When a map is drawn, the default is to include all the states or countries on the selected... KB#193468. Keywords: Microsoft Map, Colors, Format, Symbol

 
139. Excel functions for dates and times There are many functions in Excel which allow you to manipulate dates and times and perform calculations on them. The principle behind these is simple and much of the confusion relates to how the results are displayed - i.e. how your dates are formatted. If you type a date or time (e.g. 23/1/03 or... Keywords: Dates, Days, Months, Format, Styles, Formulas, NOW, SECOND, DATEDIF, CHOOSE, WEEKDAY

 
140. Pivot Tables Tutorial Using a Pivot Table as Source for Chart If you use a range of data as input to a pivot table -- and name that range " Database", the Data Form will add new records and include them in the named range. They will be included in the pivot table (after it is refreshed). You can link a chart to a pivot... Keywords: Charts, AutoFormat, Styles, PivotTables, VBA, Links

 
141. Gridlines and Borders Cell color and/or Borders wipe out gridlines: Any color within a cell such as white, or any color borders such as white, will wipe out gridlines. Draft quality wipes out gridlines and interior color as can be previewed in Print Preview. To Make sure you do not have color within a cell Cells with... Keywords: Borders, Colors, Format, Gridlines, Patterns, Printing, VBA, Macro, Toolbar, Web, Comments, Window

 
142. Protecting cells, sheets, workbooks, and files Excel offers many ways to protect your data. But understanding the differences between the methods and the limitations of each of them can be daunting. Here's a quick review of four protection options in Excel 97 and later, plus explanations of how to use them. Note: These protection features... Keywords: Charts, Sorting, Format, Formulas, Password, Printing, VBA, Files, Window

 
143. How to use Microsoft Map to Display Specific States and Nations in Excel 2000 In Microsoft Excel 2000, you can use Microsoft Map to limit the states or countries shown on a map to a given list. By default, Microsoft Map includes all the states or countries when it draws a map. Display Specific States and Nations To limit... KB#213880. Keywords: Microsoft Map, Colors, Format, Toolbar, Window

 
144. Excel -- Data Entry -- Convert Text to Numbers Convert Text to Numbers Convert with Paste Special Convert Dates with Replace All Convert with Text to Columns Convert Trailing Minus Signs Convert Trailing Minus Signs Programmatically Paste as CSV Convert Programmatically If you copy data from another program, such as Microsoft Access, or from a... Keywords: Dates, Errors, VBA, Macro, Toolbar

 
145. How to Minimize the Size of an XML Spreadsheet File When you save an Excel workbook as an XML Spreadsheet file (*.xml), and the workbook contains large ranges of special formatting, the size of the file may be much larger than the original workbook (*.xls) file size. Note To save an Excel workbook... KB#325091. Keywords: XML, Fonts, Format, Styles

 
146. How to Call a Macro Repeatedly on a Fixed Time Interval In Microsoft Excel, you can call a macro repeatedly at a set time interval using the OnTime method and the Call... KB#213288. Keywords: Format, VBA, Macro, Web

 
147. Scroll Bars in Excel Keywords: Sorting, Colors, Fonts, Formulas, Web, Comments

 
148. How to Sum and Format a Range of Hours, Minutes, or Seconds To automatically format times that when added together exceed 24 hours, 60 minutes, or 60 seconds, you can use the following custom number formats and the SUM function in Excel: Hours [h]:mm:ss Minutes [m]:ss Seconds ... KB#266691. Keywords: Custom Number Formats, Formulas

 
149. How to Create a Conditional Format to Hide Errors In Microsoft Excel, you can create conditional formatting on a cell, or a range of cells, so that error values are not displayed in the... KB#154874. Keywords: Conditional Formating, Custom Number Formats, Errors, Formulas

 
150. Excel drop down lists If you wish to present a user with a restricted choice of options and don't want to risk an item being miss-typed in a cell, drop down lists are an ideal solution. These lists display all of the available choices to the user so that they can click on their preference. Excel allows you to place two... Keywords: Format, Outline, Formulas, Combo Box, Object, Toolbar, Hyperlinks, Validation, MATCH, OFFSET

 

<< (Page 2)  Previous              Next  (Page 4) >>