• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Collaborating with Excel > Common Problems and Solutions

Common Problems and Solutions

Q1:I created a worksheet at home that included some cells with the text rotated to a 45° angle. When I brought the worksheet into the office to print it, the rotated text was no longer rotated.
A1: Check the version of Excel in the office. Versions earlier than Excel 97 could only rotate text to 90 degrees or -90 degrees. Any rotations other than those were changed to horizontal orientation.
Q2:I'm trying to delete a worksheet from my Excel workbook, but the Delete option is unavailable.
A2: Excel will not let you delete worksheets if a workbook is shared. You must first unshare the workbook by selecting Tools, Share Workbook and deselecting Allow Changes by More Than One User at the Same Time.
Q3:I need to open a workbook that has a password assigned to it, but it won't accept my password.
A3: Passwords are case-sensitive. Check to see if your Caps Lock key is turned on by mistake.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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