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

sharing spreadsheets

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

Sharing spreadsheets

ResolvedVersion 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:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.