Excel Help HQ

  • Home
  • About Us
  • HIRE US!
    • HIRE US!
    • Pricing Guideline
  1. Home
  2. Formatting

Formatting

Excel: Alternate Row Colors / Color Banding, Column Colors and Checker Patterns

Tables are often used to layout and summarize data. But have you been in a situation where the table got so big that it is not easy to read? The table is so big that it is hard to tell which rows and columns a certain cells belong. For example, in the table below, it…

Read more

Read more

  Posted in Excel, Excel 2003, Excel 2007, Excel 2010, Work Smart Tagged Formatting    2 Comments

How to get rid of text formatting in Word?

Often times, copying and pasting between different files causes major cosmetic problems due to formating issues. To solve this problem, paste the text into Notepad to get rid of the formatting: Copy the text intended to be pasted from source Paste the text into Notepad Copy the text from Notepad Paste into the intended location…

Read more

Read more

  Posted in Powerpoint, Word Tagged Formatting    Leave a comment

How to line up digits centered properly on a table in Excel?

Numbers in Excel only align left, right or center. Numbers cannot be aligned to line up properly to right while being in the center of a cell, which could look awkward for some. See below for example: In the “Right Aligned” column, all the numbers are pushed too far on the right. In the “Center”…

Read more

Read more

  Posted in Excel, Excel 2003, Excel 2007, Excel 2010 Tagged Formatting    Leave a comment

Categories

  • Access (1)
  • Adobe (1)
  • Autohotkey (1)
  • Automation (3)
  • Downloads (8)
  • Excel (45)
    • Charts (4)
    • Data Table (3)
    • Excel 2003 (29)
    • Excel 2007 (30)
    • Excel 2010 (32)
    • Lookup (2)
    • VBA Macro (11)
  • Interviewing – Getting the Job (3)
  • Other Tips (1)
  • Popular (4)
  • Powerpoint (4)
    • Powerpoint 2007 (1)
    • Powerpoint 2010 (1)
    • VBA Macro (2)
  • Windows (2)
  • Word (2)
  • Work Smart (5)

© 2025 Excelhelphq.com | All rights reserved.