• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Color Selection Looks Odd

Q1:When I select cells or ranges, the background color of my worksheet seems to go haywire.
A1: If your worksheet includes colored background fills or patterns, a range selection may display in an odd color. The displayed color change is merely the temporary result of selecting the cells. Clicking away from the selected range to deselect it will display the cells with their normal formatting.

Can't Copy Multiple Selections

Q1:After selecting several noncontiguous ranges, I try to copy them to the Clipboard but get the message That command cannot be used on multiple selections.
A1: Excel can copy noncontiguous ranges only if they're the same size and shape. If you need to copy all the information in the various selections but nothing between, and you can't arrange the worksheet to make that data contiguous, try this trick: Apply a background fill or special format to the cells you don't want (a bright yellow or green fill works nicely). Then copy a contiguous block containing all the cells you do want as well as those you don't, and paste the copy into place in its target position. The cells that then need to be cleared are easily visible because of the fill or special format. Select those cells and choose Edit, Clear, All.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint