-
WSsimmo7
AskWoody LoungerHi,
When you first register your tablet with the Android Market, it then knows what device you have and will tell you if the app is not compatible.
Regards,
Maria -
WSsimmo7
AskWoody LoungerYou can do this easily without a macro.
Home – Find and select- Edit – goto special
SteveSteve, the F5 key is a quicker way to the goto special command – I use it all the time
Regards,
Maria -
WSsimmo7
AskWoody LoungerTed,
I think part of the problem is that the mouse in question is what you might call an el-cheapo bought off the internet. My dearer Logitech & Microsoft meeces tell me when the battery is getting low with a blinking light on the top of the mouse the cheap one did not have this.
Regards,
Maria -
WSsimmo7
AskWoody LoungerOctober 6, 2011 at 11:00 pm in reply to: Sum of calculation AND worksheet name that it appears on. #1301154Hi,
See my attached file, I created a lookup listing of all the sheet names with a link to the relevant cell to find the maximum in – I then used the Max function on this list then used a lookup function against the listing of sheet names to find out which sheet had the maximum value. Hopefully you should be able to do something like this with your file.
Regards,
Maria -
WSsimmo7
AskWoody LoungerSusan,
Would you be willing to upload your file? If you have sensitive data, I suggest you replace it with dummy data. Once you have uploaded your file I can have a look at it in Excel 2007.
Regards,
Maria -
WSsimmo7
AskWoody LoungerHi, The only thing I can think of without seeing your file, is to check that the source data has no gaps between the headings and the data to be pivoted.
Regards,
Maria -
WSsimmo7
AskWoody LoungerThanks Rory, Good to know that I am not going crazy – I couldn’t figure out how sendkeys {TAB}” would turn off/on Numlock. The good thing about the new code is that if I want to change the code to move down after putting the X mark, I can simply change the offset to (1,0) instead of (0,1).
Regards,
Maria -
WSsimmo7
AskWoody LoungerThank you. That’s what I needed.
OK. I’m not 100% sure I understood this part. In other words, I should have the actual song name (in text) in another column? Or, is Column C the ‘Unique Value’ you were mentioning?
You are welcome – glad I could help. What I meant about the unique values, was that if you had instead of my Column C a full list of song numbers in Column C and Names in Column D then once you have determined which song numbers were sung most or not at all, then you could easily lookup the name of the song.
Regards,
Maria -
WSsimmo7
AskWoody LoungerYour spreadsheet would be better if you included a Unique values lookup table for Song Names and Numbers.
From your data I firstly typed a list of all 660 song numbers, I then created a counting formula to find the song number in your listing and count how many times it appeared. I then determined what count was the highest number, and created a formula to show all those rows that matched. I then did the same with any zero’s to find which songs had not been sung. To get the Top 10 you can use the filter tools on column D to get this.
See attached updated file.
Regards,
Maria -
WSsimmo7
AskWoody LoungerSteve, Thanks for that I confess I didn’t look at line 2. This code will be very useful for me, as I have a lot of very large spreadsheets with the first few rows frozen so that users always see the header rows.
-
WSsimmo7
AskWoody LoungerSteve,
A1 may not necessarily be the equivalent of CTRL+Home if panes have been frozen, it could quite easily be something like B5. I would like to know the VBA equivalent too as I use the frozen panes feature quite a lot on my larger worksheets.
-
WSsimmo7
AskWoody LoungerThanos, mine was the first wopr(1)adjusted.xls. By portrait orientation I assume you want to print it on a normal A4 sheet in portrait? If so, you only need to play around with the column widths to make it fit (in print preview mode). If you are talking about the second version that Rory did, then you will probably need to leave this in landscape as if you tried to fit it on a page in portrait mode it would be too small to read.
Regards,
Maria -
WSsimmo7
AskWoody LoungerThanos,
See Attached. I selected all the data, Inserted a Stacked Bar Graph, then right clicked on the graph created, clicked on select data and when the dialogue box came up I clicked on Switch Row Column and clicked OK. I think this is what you wanted.
Regards,
Maria -
WSsimmo7
AskWoody LoungerCan combo boxes also do what I’m trying to do with giving the total in another cell?
Is anyone else using Excel 2007? Those instructions are not for that version. I don’t see a “Control Toolbox”. It might be under Insert | Controls. There are two areas: Forms Controls and ActiveX Controls.CrazyKZ,
You can get to the Control Toolbox in Excel 2007 by choosing the Developer Tab on the ribbon. If you don’t see the Developer Tab you can set this to show in Excel Options.
You should find the Combo Box Control there, sorry I can’t help further as I have not used this feature of Excel 2007 yet.
Regards,
Maria -
WSsimmo7
AskWoody LoungerI’m not figuring this out. I was able to get everything to work correctly with the DataValidation…all except for the further editing (font size, drop down list number, etc.).
I am using Excel 2007 and none of the informaiton matches up with the instructions above on the link.
Am I needing to start over now and use a different method? Sorry, I’m confused.
I have attached what I have so far (blanked out my data for the most part) if someone can help me.Thanks!
CrazyK,
The further editing (Font size, Drop Down List Number of rows, etc) only applies to combo boxes – you are only using Data Validation in Drop down Lists not combo boxes. You would need to follow the earlier examples in the earlier links on how to create and format combo boxes.
Regards,
Maria
![]() |
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 |

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
-
Marriage Counseling – Manages To Do It Save Our Marriage? (Awaiting moderation)
by
lynwoodspellman
4 hours, 34 minutes ago -
Where’s the cache today?
by
Up2you2
4 hours, 26 minutes ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
11 hours, 32 minutes ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
11 hours, 53 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
5 hours, 8 minutes ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
21 hours, 41 minutes ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
21 hours, 47 minutes ago -
regarding april update and may update
by
heybengbeng
23 hours, 17 minutes ago -
MS Passkey
by
pmruzicka
1 hour, 13 minutes ago -
Can’t make Opera my default browser
by
bmeacham
1 day, 6 hours ago -
*Some settings are managed by your organization
by
rlowe44
17 hours, 40 minutes ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
1 day, 5 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
2 days, 1 hour ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
2 days, 10 hours ago -
AI slop
by
Susan Bradley
4 hours, 28 minutes ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
2 days, 11 hours ago -
Two blank icons
by
CR2
23 hours, 34 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
2 days, 20 hours ago -
End of 10
by
Alex5723
2 days, 23 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
1 day, 21 hours ago -
test post
by
gtd12345
3 days, 5 hours ago -
Privacy and the Real ID
by
Susan Bradley
2 days, 19 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
21 hours, 53 minutes ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
3 days, 9 hours ago -
Upgrading from Win 10
by
WSjcgc50
1 day, 21 hours ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
2 days, 1 hour ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
4 days, 1 hour ago -
The story of Windows Longhorn
by
Cybertooth
3 days, 13 hours ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
4 days, 3 hours ago -
Are manuals extinct?
by
Susan Bradley
1 day, 3 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.