Friday, December 23, 2011

How to Add a Pointer to Table in Excel 2007


1. Open the Excel file that contains the table to which you want to add the pointer.
2. Click the 'Insert' tab on the Excel Ribbon.
3. Click the 'Shapes' button. Click one of the arrow icons in the 'Lines' section to select it.
4. Click and drag your mouse from a space on your Excel worksheet to the cell in the table to which you want the arrow to point.
5. Click and drag the pointer's circular resize handles to resize the arrow to an appropriate length. Hover over the arrow you inserted with your mouse until a four-way arrow appears. Click and drag the arrow if you want to move or reposition it in the table.
6. Click the 'Format' tab in the 'Drawing Tools' section on the Ribbon. Click the options in the 'Shape Styles' group if you want to add an outline to the pointer, change its thickness and add other effects like a reflection or glow.

Blogger news