Home > Excel Help Portal > Formatting Excel

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

Formatting Excel

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

151. Opening XML Files in Excel In Microsoft Excel, you can open and save Extensible Markup Language (XML) files. This article explains how XML files are displayed when opened in... KB#282161. Keywords: Sorting, XML, Format, Styles, Errors, Files, Web

 
152. Use custom number formatting to reduce fractions Do you remember sitting through Mr. Irwin's math class in 7th grade? That was where I learned about reducing fractions. You would be given an evil fraction like 135/864 and you would have to figure that it was really 5/32. And then there were the nasty compound fractions - where you would have to... Keywords: Conditional Formating, Custom Number Formats, Formulas, Class, VBA, Web

 
153. In Cell Column Chart A reader from the Czech Republic asked about creating an in-cell chart to illustrate a percentage. If the value in a cell was 37%, he wanted to fill 37% of the cell from the bottom with a color. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either... Keywords: Charts, Colors, Errors, VBA, Web

 
154. How to Use the Paste Options Button to Paste Data from Excel This article explains how to use the Paste Options button to paste data from... KB#284751. Keywords: Fonts, Format, Styles, Clipboard, Links

 
155. RunTime Error 91 with Macro That Searches for Fill Color When you run a Microsoft Visual Basic for Applications macro that searches for a cell that contains a specific fill color in Microsoft Excel, you may receive an error message similar to the following: Run-time error '91': Object variable or With... KB#282153. Keywords: Colors, Format, Patterns, Errors, Macro, Object, VBA, Error Message, Web

 
156. How to Change the Date or Time Format in a Header or Footer In Microsoft Excel 2000, when you use the date code (&D) to enter the date in the header or footer of a document, the date appears in the default MM/DD/YY format. The time code (&T) defaults to the H:MM AM/PM format. These date and time formats... KB#213510. Keywords: Format, VBA, Macro, Setup, Web

 
157. Changing Numbers to Text Is there any way to get the formats to take without edit, replacing? Or is there a way to edit, replace without changing a specific cell. I've tried blanks & spaces, but it says that nothing is found.Yes, there are a lot of ways around this. The first approach is to simply change your VLOOKUP... Keywords: Format, Formulas, VBA, Web, VLOOKUP, VALUE

 
158. Macros to Loop Through Range and Act Based on Cell Value This article contains two sample Microsoft Visual Basic for Applications macros ( Sub procedures) that loop through a range of cells and determine whether each cell in the range meets certain... KB#213805. Keywords: Criteria, Colors, VBA, Object, Web

 
159. Excel Hall of Fame Kudos to Ivan F. Moala, our first Hall of Fame winner for his solution to the color banding problem. The Question: In order to help visually locate the active cell pointer, is there a way to have a temporary color band appear in the current row and column?... Keywords: Colors, Conditional Formating, Errors, VBA, Web

 
160. Excel -- Conditional Formatting -- Examples Examples Hide Errors Hide Duplicate Values Highlight Duplicates in Column Highlight Lottery Numbers Highlight Upcoming Expiry Dates Hide Cell Contents When Printing Hide Errors You can use conditional formatting to check for errors, and change the font colour to match the cell colour. In this... Keywords: Sorting, Dates, Days, Download, Colors, Fonts, Format, Errors, Formulas, Printing, COUNTIF

 
161. How to add Text to the XAxis or YAxis on a Chart in Excel 2000 This step-by-step article describes how to add text to a specific point on a chart in Microsoft Excel 2000. Normally, when you try to add text to the x-axis or y-axis of a chart, you cannot manually edit the numbers on the axis to change them to... KB#213958. Keywords: Charts, Colors, Custom Number Formats, Gridlines, Patterns

 
162. How to Use Conditional Formatting to Shade Every Other Row It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate... KB#268568. Keywords: Format, Patterns, Formulas, MOD

 
163. How to Create a Loan Amortization Schedule The purpose of this article is to demonstrate how to create a basic loan amortization schedule in Microsoft... KB#816643. Keywords: Format, Symbol, Formulas, Templates, Web, PMT

 
164. Protecting Charts in Microsoft Excel The VBA equivalent of this manual sheet protection is: ActiveChart.Protect Password:="drowssap", DrawingObjects:=True, Contents:=True Note: despite being protected, the chart sheet may still be deleted. An embedded chart can be protected manually by selecting Protection from the Tools menu, then... Keywords: Charts, SERIES, Text Box, Format, Formulas, Links, Object, VBA

 
165. "SYLK: File Format Is Not Valid" Error Message When You Open File When you try to open a text file or a comma-separated variable (CSV) file, you may receive the following error message: SYLK: File format is not... KB#323626. Keywords: Format, Errors, Error Message, Text Files

 
166. Jon Peltier's Web Site -- Chart Index Chart Pages Visit Jon's Home Page -- http://peltiertech.com/index.html Align (Overlay) Charts Arbitrary Axis Scale Arbitrary Gridlines Arbitrary Gridlines, Take Two Gridlines, Arbitrary, Take Two Label Last Point Probability Chart Reciprocal Axis Chart Stacked Line Chart Tertiary Y Axis Conditional... Keywords: Charts, GANTT, SERIES, Whisker, Months, Years, Statistics, Fonts, Format, Gridlines, Errors, Formulas, Links, Combo Box, VBA, Web

 
167. How to Add Text to the X or Y Axis on a Chart In Microsoft Excel, when you try to add text to the x-axis or y-axis of a chart, you are unable to manually edit the numbers on the axis to change them to... KB#137528. Keywords: Charts, Custom Number Formats, Gridlines

 
168. Arrowheads in Drawing Line in Embedded Object Appear Much Larger Than Expected When you use the Drawing toolbar to draw a line with arrowheads in an embedded object in a Microsoft Office document, the arrowheads may appear much larger than... KB#825005. Keywords: Fonts, Format, Object, Registry, Toolbar

 
169. How to use the Auto Fill Options button in Excel When you fill in data based on adjacent cells by dragging the fill handle, the Auto Fill Options button is displayed just below and to the right of your filled selection. When you click the Auto Fill Options button, a list of options appears... KB#291359. Keywords: SERIES, AutoCorrect, Dates, Days, Months, Years, Format, Errors, Smart Tag

 
170. Showing Formulas in Excel Timmy in Orrville asks the first question. I have a very complex worksheet and need to check all of the formulas. Is there any way to have Excel show or print the formulas rather than me having to move the cell pointer to check each formula in the formula bar? #"."000 MrExcel.com provides examples... Keywords: SERIES, Wildcard, Custom Number Formats, Formulas, Printing, Class, VBA, Web, Auditing

 
171. How to Create a Bullet List in Microsoft Excel Microsoft Excel does not have a built-in function to add a bullet item to entries in a worksheet. However, you can add bullets to text, or you can create a custom text format that includes bullets, so that you can format the cells and add text... KB#323567. Keywords: Bullet, Custom Number Formats, Fonts, Symbol

 
172. 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#182189. Keywords: Conditional Formating, Custom Number Formats, Errors, Formulas

 
173. Use a number format to make zeroes not appear The real problem is that if you enter this simple formula in Excel, =Z1 and cell Z1 is empty, the answer to that formula is 0 instead of a blank. This can be horribly frustrating.There is no perfect solution to this problem, but here are two ideas:1. Make the original cells with no data contain a... Keywords: Custom Number Formats, Formulas, Links, VBA, Web

 
174. The font style of text that is contained in a Microsoft Excel Worksheet Object may change in Word or in PowerPoint After you edit a Microsoft Excel Worksheet Object in Microsoft Word or Microsoft PowerPoint, the font (or font style) that is contained in the object may change or may appear... KB#834009. Keywords: Fonts, Styles, Object, Registry

 
175. Help using Excel spreadsheet functions - text, abs The Text and '&' functions are very useful for including your spreadsheet data within meaningful sentences which can be understood by a layman. Statements can be constructed which include numeric values taken from cells. The '&' symbol is not strictly a function. It is an operator which can be used... Keywords: SERIES, Dates, Custom Number Formats, Symbol, Formulas, Menu Command, TEXT, ABS, NOW

 
176. Excel -- Combining Data Combining Data You can combine data from multiple cells into one cell, either "As is", or with additional text and formatting. Also, you can combine text, and the result of a function. Combine Text from Multiple Cells Add Spaces to Combined Text Combine Text and a Number Combine Text and a... Keywords: Format, Formulas, TEXT, TODAY

 
177. Rich Text Formatting Is Lost When You Use Replace All If you use the commands in the Replace dialog box to find and replace text in a worksheet, some cells may lose their text... KB#177194. Keywords: Fonts, Format, Styles, Formulas, Toolbar

 
178. Excel: Converting Excel tables into XML files This section offers some simple guidance of how to transfer data between Excel, Access and HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL... Keywords: Criteria, Data Table, Query, Sorting, Dates, Export, XML, Format, Symbol, Macro, VBA, Files, HTML, Internet Explorer, Web

 
179. Introduction to Charting in Microsoft Excel 3D Exploded Pie Chart"The Trailer Trash of Charting" Is That a Chart, or Is Your Dog Ill?Some don't think Excel's palette has enough colors! Fax-Friendly Chart Simple Primary Colors Are Best Doesn't the column provide for easier... Keywords: Bar Chart, Charts, SERIES, Colors, Styles, Printing

 
180. 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 describes how to create a sample chart, how to use that sample chart as the basis for a user-defined chart format, and how to... KB#214265. Keywords: Charts, SERIES, Format

 
181. Macro to conditional highlight cells Ed asked this week's question. I need a simple macro that will search lets say..column C and highlight red the cells that contain todays date (current date) and highlight yellow any other cell in the column that is 15 days in the future from todays date? Users of Excel 97 or Excel 2000 can take... Keywords: Criteria, Days, Conditional Formating, Formulas, Macro, VBA, Web, TODAY

 
182. Chart Source Data Of course, charting is all about displaying data. Excel provides a multitude of ways to get the data you want to plot into a chart. You can select it prior to starting the Chart Wizard, or in Step 2 of the Wizard. Or you can get to the source data through the Source Data menu command. You can open... Keywords: Charts, Plot, SERIES, Borders, Styles, Menu Command, Discontiguous

 
183. Using Data Validation to check for repeated values Sometimes you just don't want data to repeat itself. On an order form or an inventory sheet, for instance, you may not want a part number entered in one cell to repeat in another cell. You can use Excel's Data Validation feature to to prevent a value from appearing more than once in a range. In the... Keywords: Charts, Format, Errors, Formulas, Printing, Error Message, Validation, COUNTIF

 
184. SORTING, some notes on sorting in Excel Keywords: Dates, Days, Years, Custom Number Formats, Web, Comments, Window, NOW

 
185. How to add Totals to a Stacked Column Chart in Excel 2000 This step-by-step article shows you how to add total values to a stacked column chart in Microsoft Excel 2000. In Excel, you can add data labels that automatically display the values of an individual series in a stacked chart. You can... KB#213921. Keywords: Charts, Legend, SERIES, Borders, Patterns, RIGHT

 
186. Zoomed Cells Are Not Displayed Correctly If You Freeze Panes on Outline Group In Microsoft Excel, cell contents may be not displayed correctly if your worksheet is zoomed to a magnification other than 100 percent. If the worksheet is zoomed to less than 100 percent, the characters at the edge of a cell may be truncated. If... KB#283090. Keywords: Dates, Borders, Outline, File Name, Files, Window

 
187. How to suppress #DIV/0! Error Value in Division in Excel 2000 When you divide by 0 (zero) or a blank cell, Microsoft Excel displays the error value #DIV/0! as the result of the calculation. This article shows you how to use the IF worksheet function to suppress the #DIV/0! error value. Suppress #DIV/0... KB#182188. Keywords: Conditional Formating, Errors, Formulas

 
188. Excel -- Comments -- Basics Basics Insert a Comment Display a Specific Comment Display All Comments Use the Reviewing Toolbar Format Text in a Comment Printing Comments Comments -- Tips Comments -- Programming To hide the comment: a) Edit comment b) Previous comment c) Next comment d) Show comment e) Show all comments f)... Keywords: Borders, Colors, Fonts, Format, Printing, Setup, Toolbar, Comments

 
189. Diagonal Border Disappears with Rotated Text In Microsoft Excel, when you use rotated text (any angle between 90 and -90 degrees) and a diagonal border in the same cell, the diagonal border may... KB#212129. Keywords: Borders, Format, Outline

 
190. Color, Sorting on Color What is meant by color? There is Color Index that is used by Excel, there is RGB. How are the cells colored, there is normal cell formatting and there is Conditional Formatting. Once you have a number it's not likely you could use it directly for the ordering you want. Finally obtaining normal cell... Keywords: Sorting, Colors, ColorIndex, Format, Formulas, VBA, User Defined Function, Web, Comments

 
191. Bus Schedule You cannot specify boldface in regular cell formatting. Conditional Formatting could do the boldface but that is all. A macro is needed to change the time and formatting so that that 1:00 and 13:00 both appear as 1:00 with the PM appearing in bold, and both without AM or PM. Example: Original Bus... Keywords: Fonts, Format, VBA, Macro, Web, Comments

 
192. Microsoft Excel Text Formatting May Not Convert When Opened in Word When you use Microsoft Word 2000 to open a Microsoft Excel 2000 worksheet with multiple character formats within a cell (for example some text is bold and other text is italic), all text in that cell uses the format of the first character. All... KB#211850. Keywords: Format, Setup, Files, Toolbar

 
193. How to Suppress #DIV/0! Error Value in Division When you divide by 0 (zero) or a blank cell, Microsoft Excel displays the error value #DIV/0! as the result of the calculation. This article shows you how to use the IF worksheet function to suppress the #DIV/0! error... KB#291050. Keywords: Conditional Formating, Errors, Formulas

 
194. Size of TIFF Picture Is Incorrect When Inserted When you insert a tagged image file format (TIFF) picture into a document in any of the programs listed above, the picture is larger than it should be. If you examine the original size and scaling information (On the Format menu, click Picture,... KB#144930. Keywords: Ratio, Format

 
195. Custom HTML Table from Excel I had a list I wanted to convert to HTML but surround it with graphics of my choice and be able to change on the fly. The finished product in the example is a list of ISO country codes. I actually used it for some company information that will always have the same columns but the content (number of... Keywords: Printing, File Name, Text Files, HTML

 
196. How to Format Cell Data When You Are Creating an Excel File With an Active Server Pages Page This article demonstrates how to format a field to preserve the leading digits (such as the 000 in 0001112) or a specific formula when you create an Excel file with an Active Server Pages (ASP)... KB#260239. Keywords: Format, Formulas, Internet Explorer

 
197. How to use Draw Border Tools and Draw Border Grid Tools to Apply and Remove Cell Borders in Excel This step-by-step article shows an example of how you can use the new Draw Border tools and Draw Border Grid tools in Microsoft Excel 2002. Excel 2002 provides a new approach to adding or removing borders around and between cells. Instead of... KB#288852. Keywords: Borders, Colors, Format, Styles, Toolbar

 
198. Excel -- Comments -- Tips Tips Change the User Name Change Comment Shape Add a Picture to a Comment Change the default Font Size Alternative to Cell Comments You can change the font size of new comments by changing the settings in your Control Panel. (Instructions for Windows XP) Add a comment to a Data Validation Input... Keywords: Borders, Colors, Fonts, Printing, Comments, Validation

 
199. How to Remove Gridlines from a Section of a Worksheet This article describes how to hide the gridlines on a section of a worksheet in Microsoft... KB#189883. Keywords: Borders, Colors, Format, Gridlines, Outline, Patterns, Styles

 
200. Updating Link Removes Formatting from Microsoft Excel Table In Microsoft Word, if you insert a link to a Microsoft Excel worksheet as Formatted Text (RTF) and then apply formatting (such as bold or italic formatting) to the linked table, the formatting may be lost when the link is... KB#220526. Keywords: Format, Links

 

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