sharing spreadsheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sharing spreadsheets

Sharing spreadsheets

resolvedResolved · Low Priority · Version 2007

Sally has attended:
Excel Intermediate course

Sharing spreadsheets

When I use a shared spreadsheet, I cant amend the cell widths or add in columns. How can I do this without having to unshare the workbook?

RE: Sharing spreadsheets

Hi Sally,

Normally its the first person who opens the shared document can edit it, with other people being read only. If you are the only one with the document open and you still cant change the column width etc... it may be that the workbook has been protected.

Hope that helps?

Thanks
Paul


 

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips


Server loaded in 0.08 secs.