Question about Microsoft Computers & Internet

1 Answer

Autofilter ceases to work on large Excel 2003 spreadsheet

I have a rather large spreadsheet with critical corporate data in it. The spreadsheet is 305 rows extending to column GA. It contains manually-entered data as well as vlookups pulling in data from other files.

I use autofilter to look at specific information. However, lately, it has stopped working as expected. ''Custom'' is still listed as an option, but I cannot create any custom filtering. In other, smaller spreadsheets, I get the options of All, Top 10, Custom and a listing of possible data. In this large spreadsheet, I now have Sort Ascending, Sort Descending, All, Top 10, Custom and no listing of possible data. And while Sort Ascending, Sort Descending and All work, Top 10 and Custom do not.

Any ideas?

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Posted on Jun 18, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

When importing data from Excel 2010 spreadsheet Easy Mark says you must install Excel


If you selected an Excel spreadsheet from the Data Import dialog, you will need to select which worksheet within the spreadsheet contains the label data you wish to import. If you don't have Excel installed you'll need at least Excel Viewer as Easy Mark relies on the users system to view the worksheet.

Oct 17, 2013 | Panduit Easy-Mark Labeling Software...

1 Answer

What is excel


What is Excel blankxl_250.jpg
Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

2 Answers

VLookup?


select all columns
clik on data click filter select autofilter

Jul 13, 2009 | Microsoft Excel for PC

1 Answer

Formula reqd in MS Excel


hi-lite the whole spreadsheet
go to data and select auto filter
you will see that each column will have an arrow at the top for a pull down menu
click on the city you want and you will only see the hospitals in that city
be sure to save your changes and the autofilter will be saved

May 17, 2009 | Computers & Internet

1 Answer

Squished Rows in Office 2003


Follow the next steps:
1.- Choose in the menu File.
2.- After Choose the option Sent to.
3.- After Choose the option recipient (attach data).

Nov 20, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Excel formulas


insert a row above row 1 and use data>filter>autofilter
view your database however you like

Nov 18, 2008 | Microsoft Excel for PC

1 Answer

I need to import data from access into excel where one column go into one worksheet and other into next worksheet


Acess will only export the data into an Excel spreadsheet with each element of the record going into a sperate column.

You can record macros to get the data to go where you want it to go on the spreadsheet.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Mail Merge Print Problem


Was a recipient address created in an Excel spreadsheet or a database? Data needs to be pulled from somehwere to be added to the envelope.

Dec 05, 2007 | Dell Latitude D800 Notebook

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

261 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2885 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...