Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #24  
Old 08-12-2018, 09:38 AM
p45cal's Avatar
p45cal p45cal is offline How to sort multiple columns with pages Windows 10 How to sort multiple columns with pages Office 2016
Expert
 
Join Date: Apr 2014
Posts: 963
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by thumb View Post
As for those Games1.txt, where are they in the workbook? I know what they are, it was when I was converting text files from an old Commodore computer over to the PC but I only used the text to copy and paste...or at least I thought.
You're using Excel 2013 so I'm not sure it'll look the same as mine, but if you go to the Ribbon Data tab, in the Queries and Connections section there's a Queries and Connections button, if you click it it should show you a whole raft of connections. If you right-click on one, there should be the option to delete it. There's also a bunch of related Names; if you go to the Formulas tab of the ribbon, and choose Name Manager, you'll see those Names (you can delete them easily here). You can visualise where they are on the sheet by zooming out to 30% or less (bottom right of the window usually) and they should appear highlighted.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort multiple columns with pages Macro to sort columns SerenityNetworks Excel Programming 4 09-02-2016 06:20 AM
.pdf to .xlsx - How to get sort-able columns? CCinPA Excel 0 07-05-2016 08:30 AM
How to sort multiple columns with pages Normal sort not bringing along other columns Dave Fraser Excel 2 06-06-2014 11:48 AM
quick replace, sort, change columns userman Excel 1 05-01-2012 06:24 AM
How to sort multiple columns with pages How to sort table having three columns? Bahir Barak Word 2 01-20-2011 01:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft