MICROSOFT EXCEL 2003, 2007 and 2010:Column Formatting Top 5
1. Insert Or Delete a Column:
Select column title next to location.Right click - Select Insert
2. Adjust Column Width:
Manual: Click and drag column title border.
AutoFit: Double click column title border.
3. Turn Column Titles On or Off
2007 and 2010 only: View, Headings.
2003 - Tools, Options, Window Options -
uncheck Row and Column Headings.
4. Hide or Unhide Columns:
Hide: Select Column. Right Click - Select Hide.
Unhide: Select Columns Next To Hidden Column.
Right click - select Unhide.
5. Group Columns to Hide/Unhide Data:
2003: Select columns - Data, Group and Outline, Group
2007-2010: Select columns - Data, Outline, Group
Note: Click the outline, plus or minus symbols to toggle the columns.
The Microsoft certified professionals at Brandpointe can help you conquer FOE (Fear of Excel).
Quick guides, AdobeConnect sessions, Flash videos or Skype sessions with an instructor, we can provide successful tools.
Register to become a member of our online community. We provide a seamless learning experience anytime you need it, with our Topyx learning site. www.brandpointeonline.com
Microsoft Excel 2003 and 2007:
Cell Formatting Top 10
Entering Data in Excel:
Cells have a limit of 32,767 characters. Although all data will show on the Formula Bar, only 1,024 characters will display or print.
1. Insert a blank line in a cell.
Alt and Enter Keys
2. Insert a tab in a cell.
Ctrl and Tab Keys
3. Wrap or Autofit text.
Wrap - Ctrl 1, Alignment Tab, Text Control
AutoFit - Double click row or column border.
4. Copy data in the cell above.
Ctrl "
5. Set vertical or horizontal alignment.
Ctrl 1, Alignment Tab, Text Alignment
6. Remove red or green triangles in a cell.
Red Triangle (Comments) - Right click, Delete Comment
Green Triangle (Error Checking) - Right click, Ignore Error
7. Add or Remove a border.Ctrl 1 - Border Tab8. Lock a cell.Select Cell - Ctrl 1, Protection, Locked
2007 - Right click Sheet tab, select Protect Sheet
2003 - Tools, Protection, Protect Sheet9. Display only certain cells.
(Select cells)
2007 - View, Workbook Views, Custom View
2003 - View, Custom View
10. AutoFill multiple cells (for months, days or number series)
(Select cells)
Click and drag the small black box at the end of the selection.
Contact the Microsoft certified professionals at Brandpointe for technical support, configuration options or training for Microsoft Excel. Test drive our new web-based learning community. Learn Microsoft Excel at your own pace from any computer. www.brandpointeonline.com
New Word Version Takes Font Capability Higher:
Along with other software, Brandpointe uses Microsoft Word to create a variety of training and marketing materials. We're excited about the enhancements and font flexibility added to Word 2010.
1. Added Text Effects: Glow/Soft Edges, Gradient Fill, Reflection, More 3-D and Outline options.
2. OpenType Settings: Provides a crossover between TrueType and Type 1 - for ligatures and really impressive font formatting.
3. Bonus Option: Create great looking documents and save them as PDF files. Word 2010 includes the format in Save As options.
Contact the Word certified professionals at Brandpointe for technical support, configuration options or training for Microsoft Word. Test drive our new web-based learning site. Learn Microsoft Word at your own pace from any computer. www.brandpointeonline.com
