[APRA-NW] RE: Virtual Roundtable for November: Excel tricks we love!

Candice Krupa crkrupa at alaska.edu
Thu Nov 7 15:51:00 PST 2013


After you filter, doesn't it tell you in the bottom left corner "50 of
1,000" or something similar ? If that is not it, what is that telling us
then?

Candice.

On Nov 7, 2013, at 2:48 PM, "Jessica S. Balsam" <jbalsam at uw.edu> wrote:

I don’t know, but it’s one of the reasons I don’t use filtering. Pretty
annoying.



*From:* apra-nw-bounces at mailman2.u.washington.edu [
mailto:apra-nw-bounces at mailman2.u.washington.edu<apra-nw-bounces at mailman2.u.washington.edu>]
*On Behalf Of *Susan Hayes-McQueen
*Sent:* Thursday, November 07, 2013 3:21 PM
*To:* Faulhaber, Christina; 'apra-nw at u.washington.edu' (
apra-nw at u.washington.edu)
*Subject:* [APRA-NW] RE: Virtual Roundtable for November: Excel tricks we
love!





Does anyone know how to get a row count after filtering? That’s always
bothered me too.





*From:* apra-nw-bounces at mailman2.u.washington.edu [
mailto:apra-nw-bounces at mailman2.u.washington.edu<apra-nw-bounces at mailman2.u.washington.edu>]
*On Behalf Of *Faulhaber, Christina
*Sent:* Wednesday, November 06, 2013 5:02 PM
*To:* 'apra-nw at u.washington.edu' (apra-nw at u.washington.edu)
*Subject:* [APRA-NW] RE: Virtual Roundtable for November: Excel tricks we
love!



<image001.png>Great idea to share these. I like to use the filter feature
for when what I am after is difficult to do with my query criteria, such as
when I’d have to do a lot of merge queries to get at what I am after, or
for trouble shooting groups that have shared data whose relationship is not
clear (information from our financial aid office!). The Sort & Filter
menu choice (at far right top) has a drop down for filter. After you
select the row of cells you want to filter on (first row in my example),
select the filter/funnel icon from the Sort & Filter drop down, and each
cell in the row you selected is now able to be filtered on, by selecting
the little triangle in the upper right of the filter cell. You can combine
more than one filter at a time.

<image002.jpg>



Very handy for large groups, but what I don’t like about the filter is that
I don’t know how to get an accurate count of number of rows. The
spreadsheet preserves the row numbers (understandably). So I resort to
creating a new column next to the one I filtered on and then entering 1,2,3
in the first three cells of the column and dragging that down to get the
count for the last row. I’m sure there’s a more elegant way!



Christina





*From:* apra-nw-bounces at mailman2.u.washington.edu [
mailto:apra-nw-bounces at mailman2.u.washington.edu<apra-nw-bounces at mailman2.u.washington.edu>]
*On Behalf Of *Susan Hayes-McQueen
*Sent:* Wednesday, November 06, 2013 3:57 PM
*To:* 'apra-nw at u.washington.edu' (apra-nw at u.washington.edu)
*Subject:* [APRA-NW] Virtual Roundtable for November: Excel tricks we love!







Hi everyone,



Did you know that APRA NW is hosting a webinar this month on XL Tips and
Tricks, featuring the very talented duo of Jennifer MacCormack and Amanda
Jarman? It’ll be on Wednesday the 20th from 9:30-11, and details will be
coming soon on how to join in. I’m very excited to learn how to wow my
family and friends just before the holiday season!



In the meantime, I thought we could talk on the APRA NW listserv about our
favorite XL tricks. They can be simple or complicated—don’t assume that
everyone knows everything you do!



So: *What’s your favorite thing in XL that others might not know about?*



Here’s mine:



It’s in the Print dialog— and it’s called “Scaling.” Do you ever have a
spreadsheet that is just a bit too wide to print on one page and you spend
hours on column width and font size until everything is annoyingly screwed
up? Well, FUSS NO MORE!!!!!



In the print dialog, the last thing on the left nav is called “scaling” and
you can tell your printer to do the work for you! In this case, I’ve
selected to print all the columns on one page. You can select it for rows
too. It’s lovely and makes your spreadsheet lovelier when printed.





-Susan Hayes-McQueen

Director, Advancement Research and Relationship Management

University of Washington







<image004.jpg>



_______________________________________________
APRA-NW mailing list
APRA-NW at u.washington.edu
http://mailman2.u.washington.edu/mailman/listinfo/apra-nw
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman13.u.washington.edu/pipermail/apra-nw/attachments/20131107/b8de0635/attachment.html>


More information about the APRA-NW mailing list