Berkeley CSUA MOTD:Entry 28932
Berkeley CSUA MOTD
2017/09/22 [General] UID:1000 Activity:popular

2003/7/5 [Computer/SW/Languages, Computer/SW/Apps] UID:28932 Activity:nil
7/5     Excel 2000 question: is there a way to shrink a worksheet to
        print on only 1 page - but by adjusting only 1 dimension - i.e. i
        want the width shrunk down but i don't want the height shrunk?
2017/09/22 [General] UID:1000 Activity:popular

You may also be interested in these entries...
2013/4/9-5/18 [Computer/SW/Languages/C_Cplusplus, Computer/SW/Apps, Computer/SW/Languages/Perl] UID:54650 Activity:nil
4/04    Is there a good way to diff 2 files that consist of columns of
        floating point numbers, such that it only tells me if there's a
        difference if the numbers on a given line differ by at least a given
        ratio?  Say, 1%?
        \_ Use Excel.
           1. Open foo.txt in Excel.  It should convert all numbers to cells in
2012/12/18-2013/1/24 [Computer/SW/Languages/Perl] UID:54561 Activity:nil
12/18   Happy 25th birthday Perl, and FUCK YOU Larry Wall for fucking up
        the computer science formalism that sets back compilers development
        back for at least a decade:
        \_ I tried to learn Perl but was scared away by it.  Maybe scripting
           lanauages have to be like that in order to work well?
2012/11/7-12/18 [Computer/SW/Languages] UID:54526 Activity:nil
11/7    If I don't need to print for a few months, do I need to keep adding
        new ink to inkjet printers to prevent them from drying and clogging
        heads? Or will it just magically work once I add in new ink
        in a few months?
        \_ The nozzles will clog. Print a test sheet every couple weeks.
           Or remove the cartridges and put cellophane tape over the nozzles,
2010/8/29-9/30 [Consumer/Camera, Computer/SW/Languages] UID:53939 Activity:nil
8/28    Hi, anybody printed a photo image to a big plotter?  Something like
        36"x36"?  I'm wondering how many megapixels the image need to
        have in order for the print to "look good".  There is a rule of
        thumb?  Like 6 megapixel is good for X size print.  10 megapixel
        is good for Y size print.  Thanks.
        \_ You don't need that many more megapixels for much bigger prints,
2009/8/8-14 [Computer/SW/WWW/Browsers, Computer/SW/Security] UID:53254 Activity:low
8/6     mrauser, what ddya think of this:
        \_ Sorta tl;dr.  It seems pretty dense, so I'll read it eventually...
           just haven't really had the time. -mrauser
           \_ yep, it's dense but pretty good. - !OP
2009/4/24-28 [Computer/SW/Languages/Functional] UID:52902 Activity:nil
4/23    what book is this?
        "I'm reading this horrible horrible book about a programmer
         from silicon valley that gets magically
         transported into some world where magic is real
         and uses computer programming skillz to become the world's
         greatest sorceror … in book 1 of the series
2008/9/1-3 [Computer/Companies/Google] UID:51015 Activity:moderate
9/1     THE GOOG had Scott McCloud do a comic explaining why THE GOOG Chrome
        (their open-source webbrowser) is cool.  I don't really think it worked
        \_ Oh boy, it comes with porn mode!
        \_ Oh boy, it comes with a porn hider feature!
2008/3/17-21 [Computer/SW/Apps] UID:49481 Activity:kinda low
3/17    Is there a way to compare differences between two substantially
        similar Excel and/or Powerpoint documents other than going through
        them manually?
        \_ In Excel 2003, there is a "Compare and Merge Workbooks..." option
           under the Tools menu.  (But for some reason it is greyed out in my
           Excel 2003.)  In PowerPoint 2003 there is "Compare and Merge
2008/1/5-7 [Computer/SW/Apps] UID:48895 Activity:moderate
1/5     I'm an Excel novice who needs help. Let us say I have a column of
        data A. I then take the absolute value of A1 and enter it in B1:
        (B1=ABS(A1)). All is good. My problem is when I want to delete
        Column A, Column B is still referencing A. How do I tell Excel to
        stop referencing the source data and instead let me have the
        result standalone? I don't want to keep A around anymore, but I
2007/5/13-14 [Computer/SW/OS/Windows] UID:46613 Activity:nil
5/13    Someone please give us a 411 on Windows Vista? Is activation
        tougher than WinXP sp2? Is it impossible to get around now forcing
        you to pay for upgrades? Let me just say that I don't like Windows
        OS.  I don't mind using Microsoft Word, Excel, and Powerpoint,
        and they actually make decent games. However, for over a decade
        I've been sucked into using Windows3.0/95/98/2K/XP because
2006/7/13 [Computer/SW/Apps] UID:43668 Activity:nil
7/13    In Excel, is it possible to average every 24th column in a particular
        row.  I googled this and found,_Excluding_Zeros%09/862.html
        though I can't get it to work.  In my spreadsheet, I have
        It makes sense, but won't work.  It seems to do the if logic only
        on the first column, and then just average the entire range, rather
2006/6/13-15 [Computer/SW/Security] UID:43377 Activity:nil
6/13    ok, memorizing all these passwords is driving me insane. I
        know this has been asked before but I cant find it: whats the
        best way to keep a password-protected file of very sensitive
        information? in this case, all my other passwords. thanks
        \_ I use
        \_ Whatever happened to this single login thing called the
2006/5/15-16 [Computer/SW/Apps] UID:43062 Activity:low
5/15    MS Excel question: I have a moderately large sheet with one column
        filled with entries that are in this form: "num; stuff", meaning
        it's a number followed by a semicolon followed by anything. Is there
        a way to split up this column into 2, with the first containing
        the number and the second containing everything after the semicolon?