[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

can not highlight multiple rows after applying filter

Posted on 2014-04-23
4
Medium Priority
?
43 Views
Last Modified: 2014-11-06
Hi,

One of my coworkers has an excel file, he can highlight multiple rows than fill in color without problems.  But after he applied filter, (the row number became blue), he can still highlight rows, but can not fill in color.  any ideas?  thx
0
Comment
Question by:mcrmg
3 Comments
 
LVL 19

Expert Comment

by:Ken Butters
ID: 40018173
What version of Excel?  I have 2010... cannot reproduce your results.
0
 

Accepted Solution

by:
mcrmg earned 0 total points
ID: 40029963
After restart, it looks fine now...no idea.....thank you
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40425779
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question