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
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
need help in Excel 2002 (Excel 2002)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » need help in Excel 2002 (Excel 2002)
- This topic has 8 replies, 4 voices, and was last updated 23 years, 1 month ago.
AuthorTopicViewing 3 reply threadsAuthorReplies-
WSTricky
AskWoody LoungerApril 28, 2002 at 6:35 am #584994There 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.
-
WSTricky
AskWoody LoungerApril 28, 2002 at 6:47 am #584997There 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.
-
WSjebby
AskWoody Lounger -
WSunkamunka
AskWoody Lounger
-
-
-
WSjharrisiii
AskWoody LoungerApril 28, 2002 at 7:21 am #585000These 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 SubDrop Down Lists aren’t too hard.
Look in Help | index | drop-down lists, | data validation
Hope this helps.
-
WSjebby
AskWoody Lounger
-
-
WSunkamunka
AskWoody LoungerApril 28, 2002 at 12:32 pm #585021Try 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
-
WSjebby
AskWoody Lounger
-
Viewing 3 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Windows Spotlight broken on Enterprise and Pro for Workstations?
by
steeviebops
5 hours, 32 minutes ago -
Denmark wants to dump Microsoft for Linux + LibreOffice
by
Alex5723
6 hours, 59 minutes ago -
How to get Microsoft Defender to honor Group Policy Setting
by
Ralph
6 hours, 9 minutes ago -
Apple : Paragon’s iOS Mercenary Spyware Finds Journalists Target
by
Alex5723
16 hours, 17 minutes ago -
Music : The Rose Room – It’s Been A Long, Long Time album
by
Alex5723
17 hours, 23 minutes ago -
Disengage Bitlocker
by
CWBillow
7 hours, 21 minutes ago -
Mac Mini M2 Service Program for No Power Issue
by
Alex5723
19 hours, 23 minutes ago -
New Win 11 Pro Geekom Setup questions
by
Deo
4 hours, 4 minutes ago -
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
1 day, 2 hours ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
1 day, 2 hours ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
1 day, 6 hours ago -
New PC transfer program recommendations?
by
DaveBoston
1 hour, 57 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
1 day, 10 hours ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
1 day, 10 hours ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
23 hours ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
3 hours, 3 minutes ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
11 hours, 57 minutes ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
2 days, 5 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
1 day, 3 hours ago -
System Restore and Updates Paused
by
veteran
2 days, 8 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
1 day, 19 hours ago -
Turn off right-click draw
by
Charles Billow
2 days, 11 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
2 days, 14 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
1 day, 8 hours ago -
Master patch listing for June 10, 2025
by
Susan Bradley
2 days, 16 hours ago -
Suggestions for New All in One Printer and a Photo Printer Windows 10
by
Win7and10
1 day, 19 hours ago -
Purchasing New Printer. Uninstall old Printer Software First?
by
Win7and10
2 days, 22 hours ago -
KB5060842 Issue (Minor)
by
AC641
1 day, 10 hours ago -
EchoLeak : Zero Click M365 Copilot leak sensitive information
by
Alex5723
3 days, 5 hours ago -
24H2 may not be offered June updates
by
Susan Bradley
1 day, 22 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.