Open Office Spreadsheet

LouBlue

Hi all.

I have done a spreadsheet on Open Office and I want to put July on the tab(sheet) at the bottom, but there isn't one. How do I add one?

Many thanks

Lord_Gardener

I think like with Excel you need to go to Menu bar, then Tools, then Options, openoffice.org calc, then view. You should get a pop-up window which should give a sheet tab option to tick!

f1charlie

This is for Excel, but should be something the same for Openoffice.

If you mean you want to name your worksheet, then right click on the tab and select rename. Type what you want to call the sheet.

If you want to add a new sheet, go to Insert>Worksheet, or right click on the tab of an existing sheet and select Insert.

toastydave

In openoffice

Right click the tab on the work sheet, you then get a menu to rename the sheet or insert new one

LouBlue

Thanks for the replies. But there is no tab, so I can't right click on it to rename it, or add another one.

espresso

LouBlue wrote: »

Thanks for the replies. But there is no tab, so I can't right click on it to rename it, or add another one.

I don't use Open office but surely you can add another worksheet, presumably Insert, Worksheet.

LouBlue

espresso wrote: »

I don't use Open office but surely you can add another worksheet, presumably Insert, Worksheet.

I have clicked on Insert and the options are

Insert

Page Break
Row
Column
Range Name

espresso

You should find what you need here.

LouBlue

espresso wrote: »

You should find what you need here.

I did look at that before I did the thread and it didn't help. It says click on the tab...there isn't one....or select one of the sheet tabs and insert another.....I don't have a sheet tab.

espresso

LouBlue wrote: »

I did look at that before I did the thread and it didn't help. It says click on the tab...there isn't one....or select one of the sheet tabs and insert another.....I don't have a sheet tab.

If you open a new workbook, File > New > Spreadsheet do you then get Sheet tabs? You may need to enable a display option.

LouBlue

Just opened a new worksheet and the same thing, no tabs at the bottom. Where would I find the Display Option?