need help in Excel 2002 (Excel 2002)

Topic

New Reply

Hi,
I just installed my excel 2002 and need help.WOuld be obliged if anyone can help me. I use this worksheet often to calculate the landed cost of goods.I have a few areas in which i would welcome any help.see attached file

Reply | Quote

Replies

There were several questions on your spreadsheet. I will tackle a few of them for you in separate posts..

Print Settings: First you will select (highlight) the area of the sheet that you wish to print and then click on File|Print Area|Set. Secondly, you will click on File|Page Setup and set the number of pages, the margins, orientation, etc. Thirdly, from the Page Setup dialog, you can choose Print Preview to see what your printed page will look like. Lastly, once you’re happy with the print settings, Save the File. The print settings will be saved, also. Next time you open the file, you will just click on the Print icon without having to go through the setup process, again.

Reply | Quote

There were several questions on your spreadsheet. I will tackle a few of them for you in separate posts..

Drop Down Lists – I can see where this will be a benefit to you in a few places but it’s probably not the best choice for placing a date on the form (the list would be infinite)!! The keyboard shortcut Ctrl + ; works good for dates. That’s Control and the semi;colon key.

There is more than one way to deal with the other “drop down boxes” you want. Data Validation, ListBoxes and ComboBoxes. From what I see on your sheets, I believe Data Validation will be the way to go.

While Excel is open, Tap the keyboard F1 key. Type in “list box” in the selected area and tap the Enter key. There lies step by step instructions on using Data Validation.

THis should get you started.

Reply | Quote

Thanks for ur help.The printing solution works fine.
With regard to the date—-nice shortcut –thnks –but still doesn’t solve my problem. Require a drop down list as the dates vary for different invoices
thnks
jb

Reply | Quote

[/list]On the date issue, from where is the workbook going to get its list of dates to populate the drop down box?

Reply | Quote

These two macros will put the sheet name in B1 and set the worksheet to print as one page.

Sub GetTabName()

Range(“B1”) = ActiveSheet.Name

End Sub

Sub OnePagePrint()

With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
End Sub

Drop Down Lists aren’t too hard.

Look in Help | index | drop-down lists, | data validation

Hope this helps.

Reply | Quote

thanks for ur help.

jb

Reply | Quote

Try the attached for your Meters to Feet conversion.

• The conversion formula is in D31, but it could be anywhere.
• The Custom Format of “;;;” (without the quotes) has been used to hide it. (Look at Format|Cells|Number|Custom – and then scroll down to the very end.)
• The conversion formula then has been given a name – using Insert|Name|Define – of “m_ft” (without the quotes).
• Whenever you need to use the conversion factor simply type: *m_ft. (This will continue to apply if your workbook ends up having many sheets in it.) [/list]HTH

Reply | Quote

thanks.it worked
jb

Reply | Quote