Home > Excel Help Portal > Formatting Excel

<<  (Page 1)  Previous              Next  (Page 3)  >>

Formatting Excel

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

51. Organization Charts from Office 2000 Programs Appear Different in Office XP Programs An organization chart may change when you try to edit it. This behavior may occur when all of the following conditions are true: The organization chart changes... KB#293615. Keywords: Charts, OLE, Format, Styles, Object, Setup, CD-ROM, Files, Registry

 
52. How to Use Natural Language Formulas Microsoft Excel 97 introduces natural language formulas, which is a method of referring to a cell range in a table by using row or column labels as the reference name. Natural language formulas use the intersection feature that is available in... KB#161881. Keywords: Format, Arrays, Errors, Formulas, Defined Name, Natural language, Toolbar

 
53. Create a Magic Square for any number in Excel Many years ago, I worked at Telxon with Dave Strong. Dave had mentioned that his grandfather would perform a trick where he would ask someone in the room for any number. He would then think very hard and slowly but deliberately build a 4x4 matrix. Every row, column, and diagonal of numbers would... Keywords: Years, Download, Patterns, Formulas, Macro, VBA, Files, Web

 
54. Inserting and Formatting Text in Headers and Footers In Microsoft Excel, you may want to use a header or footer in a worksheet. The More Information section of this article discusses the formatting codes that you can use to automatically insert and format text in a header or footer, and it... KB#142136. Keywords: Fonts, Format, Outline, Printing, VBA, Macro, Setup, File Name, Web

 
55. Excel 2002 PostService Pack 2 Hotfix Package: August 10, 2003 This article describes the Microsoft Excel 2002 issues that are fixed in the Excel 2002 Post-Service Pack 2 hotfix package that is dated August 10, 2003. Issues that are fixed in the hotfix package The following issue is fixed in this hotfix... KB#823969. Keywords: Charts, Text Box, Dates, Fonts, Format, Object, File Name, Files, Registry, Hyperlinks, Web

 
56. Navigating within a Sheet and Around a Workbook You would use the RtArrow key though you could change the direction of the Enter key from Down to Right. Use of the TAB key as mentioned before would take you to A1 if you attempt to go outside the used range. Navigation to Another Sheet (#anothersheet) Some VBA Code Sheets("My Sheet").Select... Keywords: Borders, Colors, Formulas, VBA, Macro, Toolbar, Hyperlinks, Web, Comments, Validation

 
57. Macro to Search for Cell Formats: Font, Border, and Interior In Microsoft Excel, there is no built-in feature to allow you to search on the characteristics of a cell. However, you can create a Microsoft Visual Basic for Applications procedure that allows you to search this... KB#213622. Keywords: Borders, Colors, ColorIndex, Fonts, Format, Outline, Patterns, Styles, VBA, Macro, Object, Toolbar, Web

 
58. VBA Fundamentals Tutorial Return on Investment and Return on Equity Business Model Workbook model of key inputs to the ROI and ROE measures including profit margin, asset turnover and equity multiplier. Du Pont style analysis of performance using goal seek and multiple scenarios. Highlighting and Exporting Cell Notes You... Keywords: Criteria, ROE, ROI, Colors, Fonts, Format, Styles, Errors, Formulas, Printing, Command Button, Macro, Object, OnEntry, VBA, Error Message, Goal Seek, Scenarios, Comments, Validation

 
59. How to determine the Order in Which Shapes Are Added to Diagrams in Office Programs This step-by-step article describes the order in which shapes are added to diagrams. When you add a new shape to a conceptual diagram in Microsoft Office XP, the decision about how and where the shape is added depends on the type of diagram.... KB#293184. Keywords: Text Box, AutoFormat, Colors, Styles

 
60. Paste / Pasting Keywords: Borders, Format, Patterns, Errors, Formulas, Sounds, Clipboard, VBA, Macro, Toolbar, Web, Comments

 
61. How to use Microsoft Map to Display Postal Code Centers in Excel 2000 This step-by-step article explains how to use Microsoft Map in Microsoft Excel 2000 to display postal code centers on inserted maps for the United States, Canada, or the United Kingdom. Postal Code Formats Microsoft Map can evaluate postal code... KB#213882. Keywords: Microsoft Map, Colors, Fonts, Format, Symbol, Object

 
62. How to Concatenate DDE to MSQuery Statements In Microsoft Query, to use concatenated variables, and to know where and how to break a line of code for Line Continuation, you need to know how dynamic data exchange (DDE) to Microsoft Query statements are formatted. This article provides... KB#149248. Keywords: Query, DDE, Format, Styles, VBA, Web

 
63. The Chart Wizard button on the Insert menu (shown below). The data can be selected prior to running the chart wizard, filled in while running the chart wizard, or added to the chart later. The Chart Wizard runs through a series of steps that help you set up your chart. The Standard Types tab of Step 1 of the Chart... Keywords: Charts, Plot, SERIES, Colors, Fonts, Patterns, Styles, Object, Web

 
64. How to create a Gantt chart using hours as the scale You can use a Gantt chart to show the progress of a project or the relationship among the tasks in a project in relation to time. The unit of time that is most frequently used is the day unit. However, you can also use the hour as the unit of time... KB#213915. Keywords: Charts, GANTT, SERIES, Format, Patterns, Formulas

 
65. How to Create a Biorhythm Chart It is possible to use Microsoft Excel to create a biorhythm chart. A biorhythm chart tracks the physical, emotional, and intellectual cycles of a person over a 29-day period. These three cycles are further broken down to the following day... KB#151439. Keywords: Charts, Legend, SERIES, Dates, Days, Format, Patterns, Styles, Formulas, TODAY, SIN

 
66. Smart Tag Functionality in Excel This article describes the functionality of the smart tags feature in Microsoft... KB#289148. Keywords: AutoCorrect, Sorting, Format, Symbol, PivotTables, Clipboard, Smart Tag, Internet Explorer, Web

 
67. How to Run a Macro When Certain Cells Change In Microsoft Excel, you can create a macro that is called only when a value is entered into a cell in a particular sheet or in any sheet that is currently open. Note, however, that you should not call macros unnecessarily because they slow down... KB#142154. Keywords: Colors, ColorIndex, Formulas, VBA, Macro, Object, Web

 
68. Goto Special Blanks to clean up a pivot table This tip is an extension of last week's tip. You can use the Go To Special command to select the blank cells from a range. This is great for cleaning up data in a pivot table. Pivot tables are wonderful tools. But what if your pivot table is just an intermediate step in your data manipulations and... Keywords: Sorting, Months, Format, Outline, Styles, Formulas, PivotTables, VBA, Web

 
69. How to Export Data to Microsoft Excel This article describes how to export data from MSN Money Investing into Microsoft Excel. This process can also be used to import the data into other programs that recognize text files and Hypertext Markup Language (HTML). This article includes... KB#179510. Keywords: Charts, Export, Format, Symbol, File Name, Files, Text Files, HTML

 
70. How to Create a Map with Microsoft Data Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to graphically represent data that is associated with geographic regions. This article describes how to create a map on a worksheet in Microsoft... KB#147637. Keywords: Microsoft Map, Charts, Rank, Sales, Colors, Format, Styles, Symbol, Toolbar

 
71. Conditional Formatting to Make Due Dates Stand Out =(E2-TODAY()) We are almost there. Once you go through all of these steps to get the conditional format set up for the first cell, it is easy to use the Paste Special feature to copy the formats to your entire range of dates. When you Paste Special - Formats, the conditional formatting will be... Keywords: Dates, Days, Borders, Colors, Conditional Formating, Fonts, Patterns, Formulas, Sounds, Macro, VBA, Web

 
72. How to Create a Spiral Chart It is possible to create a chart in Microsoft Excel that resembles a spiral or spirograph. The spiral chart is an XY Scatter chart that plots the series of values 1 through 128 against the cosines of those... KB#151445. Keywords: Charts, Legend, SERIES, Format, Patterns, Formulas, ROW, SIN, COS

 
73. How to Automate Excel to Create a New Workbook from Delphi This article demonstrates how to create and manipulate an Excel workbook using Automation from... KB#231614. Keywords: Charts, Sales, Borders, Colors, Fonts, Format, Arrays, Formulas, Class, Object, Window, COLUMN, RAND

 
74. Gantt chart on a worksheet MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Charts, GANTT, Dates, Years, Borders, Colors, Conditional Formating, Patterns, Formulas, VBA, Web

 
75. How to AutoFilter Records Based on Cell Formatting This article describes how to use the AutoFilter feature of Microsoft Excel to filter records in a database where a particular field has been formatted to a bold... KB#151449. Keywords: AutoFilter, Colors, Fonts, Format, Formulas, Defined Name

 
76. How to plot Values Against a Recommended Range in Excel 2000 This step-by-step article shows you how to create a chart that is a combination of the line and area chart types, this chart plots your data against a recommended range. In Microsoft Excel it is possible to display collected data against a desired... KB#211938. Keywords: Charts, Legend, Plot, SERIES, Colors, Format, Gridlines, Toolbar

 
77. How to Display Postal Code Centers in Microsoft Map In Microsoft Excel, you can use Microsoft Map (Microsoft Data Map in Microsoft Excel 7.0) to display postal code centers on inserted maps for the United States, Canada, or the United... KB#192609. Keywords: Microsoft Map, Colors, Fonts, Format, Symbol

 
78. How to create Two Pie Charts in One in Excel 2000 This step-by-step article shows you how to create two pie charts on one chart sheet in Excel 2000. Pie charts show the relationship or proportions of the parts to the whole. This chart type is useful for emphasizing a significant element. Normally,... KB#213928. Keywords: Charts, Legend, SERIES, OLE, Format

 
79. Fractions rounded to 1/4, 1/8, 1/16, 1/32, 1/64, 1/128 The formatted display of fractional measurements in Excel leaves a lot to be desired. ; This example and the formulas shown below were generously provided by Bernie Deitrick as a follow-up to a posting 2000-08-04 in the microsoft.public.excel.misc newsgroup. Bernie's formulas will be simplified... Keywords: Analysis ToolPak, Download, Format, Formulas, HTML, Links, Comments, MROUND, TEXT

 
80. How to autoFilter Records Based on Cell Formatting in Excel 2000 This step-by-step article describes how to use the AutoFilter feature of Microsoft Excel to filter records in a database based on cell formatting in certain fields. Filter Based on a Bold Font Start Microsoft Excel, and then type the following data... KB#213923. Keywords: AutoFilter, Colors, Fonts, Format, Formulas, Defined Name

 
81. How to Plot Values Against a Recommended Range In Microsoft Excel, it is possible to display collected data against a desired or recommended range for the data. This range is usually displayed as a shaded or patterned bar on the plot area against which the data is plotted. This article contains... KB#161670. Keywords: Charts, Legend, Plot, SERIES, Colors, Format, Gridlines, Toolbar

 
82. Clear Constants from Selected Cells You can combine the two statements into one statement. Selection.SpecialCells(xlCellTypeConstants, 23).ClearContents Fixing those things our macro might look like the... Keywords: Fonts, Format, Errors, Formulas, VBA, Macro, User Defined Function, Toolbar, Web, Comments

 
83. Excel Data Changes Font Format After You Edit the Excel Data in Word If you paste Excel data in a Microsoft Word document, and then you edit the Excel data, the font format of the data may... KB#814020. Keywords: Dates, Download, Fonts, Format, Object, File Name, Files, Registry, Web

 
84. Help using Excel - a VB module to generate HTML web pages Excel contains an option to save a worksheet as an HTML file. These generated pages are often unattractive to look at and contain vast amounts of unnecessary code - making the web page slow to load. If you have a minimal knowledge of HTML coding and can recognise the workings of a simple VB macro,... Keywords: Dates, Fonts, Format, Styles, Arrays, Formulas, Printing, VBA, Macro, Text Files, HTML, Web

 
85. How to reset the last cell in Excel Microsoft Excel keeps track of all the cells that you use in a worksheet by using an active cell table (also named a dependency table). Sometimes, the last cell in this table may refer to a cell that is outside the worksheet area that you are... KB#244435. Keywords: Add-In, Download, Format, Errors, Printing, Macro, VBA, Error Message, Web, Window

 
86. Equal Length Cells per Column Name QTY Size Hooded Color Logo Abe 1 S Y Red Team Bob 1 XL N Blue School Chuck 2 L N Blue Team Chuck 2 M Y Red Team Dwain 1 S Y Red Team Evan 1 M N Blue School Frank 2 XXL Y Blue School Fred 2 M Y Red Team George 3 S N Blue School Hal 1 S Y Red Team Harvey 1 XL Y Blue School Jim 2 XXL Y Blue Team... Keywords: Colors, Fonts, Links, PivotTables, VBA, Macro, Web, Comments

 
87. Unexpected Behavior with Numbers Formatted as Text In Microsoft Excel, if a number is formatted with the Text number format, and you attempt to change the format to something other than Text, the number may not be changed as you... KB#141765. Keywords: Format, VBA, Macro, Toolbar, Web

 
88. Greenbar Formatting in Excel If you are over a certain age, you will remember when all computer reports were produced by the MIS department using COBOL and a high-speed IBM Line Printer. These reports always printed on paper called "Greenbar". Four rows were shaded in green, then four rows were shaded in white. These reports... Keywords: AutoFilter, Sorting, AutoFormat, Colors, Conditional Formating, Outline, Patterns, Formulas, VBA, Macro, Web, MOD

 
89. Excel: Converting XML and Excel files The following methods are only intended to be examples - very little explanation is offered and so it should be viewed in conjunction with an XML and XSL tutorial such as that offered by W3C schools. I am only illustrating the display of tables of data, not individual records. If you wish to copy... Keywords: SERIES, Criteria, Sorting, XML, Format, Styles, Class, VBA, Files, Text Files, HTML, Links, Web

 
90. Comma Separated Values, .CSV files Some HELP items to read more on this subject. File format converters supplied with Microsoft Excel Help - Wizard -- csv: When a CSV file is read in with the .csv extension it will be read in automatically by Excel. The same file with a .txt extension will be processed by the Text Import Wizard and... Keywords: Format, Arrays, VBA, Macro, Files, Window, INDEX

 
91. Coloring within Ranges, Examples This page contains macros and code snippets. Assistance to Install a Macro or User Defined Function Don't know if this is going to go much of anywhere I'm still trying to figure out joining object properties together I notice in XL2000 that sometime in the VB Editor you get hints as to what to type... Keywords: Colors, Format, Formulas, VBA, Macro, Object, User Defined Function

 
92. How to Add Totals to a Stacked Column Chart This article contains information about adding total values to a stacked column chart in Microsoft... KB#151521. Keywords: Charts, Legend, Plot, SERIES, Borders, Format, Patterns, RIGHT

 
93. 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#164317. Keywords: Custom Number Formats, VBA, Web

 
94. Excel as Gridpaper for Drawing I always knew that Excel could be used to create some amazing drawings, but this week's tip shows some new uses for Excel. These ideas are from Don Heckerman a former associate from my days at Telxon. Don is now the head of I.T. infrastructure in the Americas for a global logistics company. He... Keywords: Days, Borders, Fonts, Patterns, Sounds, VBA, Toolbar, Web, Column Width

 
95. Chart Types in Microsoft Excel Excel allows you to create charts in a variety of types: Bar Charts, Column Charts, Line Charts, Area Charts, Scatter Charts, Pie Charts, Stock Charts. You can define a chart type when creating your chart in Step 1 of the Chart Wizard, or on an existing chart using the technique descibed below. You... Keywords: Charts, Plot, SERIES, OLE, Colors, Patterns, Menu Command, Web

 
96. How to Open XML Files in Excel In Microsoft Excel, you can open and save Extensible Markup Language (XML) files. This article describes how XML files are displayed when you open them in... KB#827294. Keywords: XML, Format, Styles, Errors, Files, Web

 
97. Sample Macro to Remove User Name from Comment By default, the text of a cell comment contains the user name in the first line of the comment. There is no built-in feature that automatically disables inserting the user name in the comment text. However, you can use a Visual Basic for... KB#213766. Keywords: AutoShapes, Colors, Fonts, Patterns, VBA, Macro, Web, Comments

 
98. Status Bar Tools, Options, View: Formula bar, Status bar, Comments and Indicator, objects, Page Breaks, Formulas, Gridlines, Row & column headers, Outline symbols, Zero values, Horizontal scroll bar, Vertical scroll bar, Sheet tabs. Status Bar (#statusbar) The Status bar is at the bottom of the Excel... Keywords: AutoFilter, OLE, Outline, Formulas, Macro, Web, Comments, Validation

 
99. How to use New "Find and Replace" Dialog Box in Excel 2002 This step-by-step article tells you how to use the Find and Replace dialog box in Microsoft Excel 2002. In Excel 2002, the separate Find and Replace dialog boxes are replaced by a single Find and Replace dialog box with new search and replace... KB#288291. Keywords: Colors, Format, Errors, Macro

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

 

<< (Page 1)  Previous              Next  (Page 3) >>