Sharing spreadsheets

Resolved · Low Priority · Version 2007

Mon 28 Jan 2013, 16:14 Delegate Sally said...

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?

Tue 29 Jan 2013, 11:52 Trainer Paul said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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