• Vincenzo

    Vincenzo

    @vincenzo

    Viewing 13 replies - 736 through 748 (of 748 total)
    Author
    Replies
    • in reply to: Formatting Margins in multiple sheets (XP) #823402

      OK will do. I’ll report back if I find the problem.
      Thanks for the help.

    • in reply to: Formatting Margins in multiple sheets (XP) #823354

      I did as you suggested, created a new workbook. Same thing. The formatting changes to the rest of the sheets in the Group are lost as soon as I de-select the Group.

    • in reply to: Formatting Margins in multiple sheets (XP) #823355

      I did as you suggested, created a new workbook. Same thing. The formatting changes to the rest of the sheets in the Group are lost as soon as I de-select the Group.

    • in reply to: Formatting Margins in multiple sheets (XP) #823344

      I tried it again, something strange is going on. I decided to test using something simple, I chose Center Horizontally. When I started, sheet A and sheet B were both left justified when viewed in Print Preview. I select both sheets by cntrl clicking on their tabs, they both turned white. I went into Print preview/setup/margins for sheet A and checked Center Horizontally. Print Preview now showed both sheets centered. Then I clicked on the tab for another sheet and therefore de-selected A and B as a Group. When I went and looked again at Print Preview for A and B, Sheet A was still centered, but Sheet B went back to being left justified. The change only seemed to affect both sheets as long as they remained both selected, as a Group.

    • in reply to: Formatting Margins in multiple sheets (XP) #823345

      I tried it again, something strange is going on. I decided to test using something simple, I chose Center Horizontally. When I started, sheet A and sheet B were both left justified when viewed in Print Preview. I select both sheets by cntrl clicking on their tabs, they both turned white. I went into Print preview/setup/margins for sheet A and checked Center Horizontally. Print Preview now showed both sheets centered. Then I clicked on the tab for another sheet and therefore de-selected A and B as a Group. When I went and looked again at Print Preview for A and B, Sheet A was still centered, but Sheet B went back to being left justified. The change only seemed to affect both sheets as long as they remained both selected, as a Group.

    • in reply to: Decimal places in pie chart percentages (XP) #820030

      Wow! thanks everybody. I will try all these to see how they work.

    • in reply to: Decimal places in pie chart percentages (XP) #820031

      Wow! thanks everybody. I will try all these to see how they work.

    • in reply to: Print column titles on all pages? (XP) #819234

      Great! That did it!
      Thanks

    • in reply to: Print column titles on all pages? (XP) #819235

      Great! That did it!
      Thanks

    • in reply to: Print column titles on all pages? (XP) #819228

      Thanks for the info.
      When I went there and clicked the selection box next to Rows to Repeat at Top, I cntrl-clicked the 2 rows at the top, and it selected them all the way across the sheet. I hit Enter, then clicked OK, and it said “Print titles must be contiguous and complete rows or columns”. But it seems like they are.
      Any ideas?
      Thanks

    • in reply to: Print column titles on all pages? (XP) #819229

      Thanks for the info.
      When I went there and clicked the selection box next to Rows to Repeat at Top, I cntrl-clicked the 2 rows at the top, and it selected them all the way across the sheet. I hit Enter, then clicked OK, and it said “Print titles must be contiguous and complete rows or columns”. But it seems like they are.
      Any ideas?
      Thanks

    • in reply to: Sum in ExcelXP (ExcelXP) #792931

      That did it! Thanks
      By the way, any recommendations for a book or online tutorial on Excel?

    • in reply to: Sum in ExcelXP (ExcelXP) #792932

      That did it! Thanks
      By the way, any recommendations for a book or online tutorial on Excel?

    Viewing 13 replies - 736 through 748 (of 748 total)