How to select 2 (multiple) columns in Excel on Mac?

Discussion in 'Mac Basics and Help' started by realchimera, Aug 24, 2011.

  1. realchimera macrumors regular

    Joined:
    Aug 23, 2011
    Location:
    Boston
    #1
    I used to hold ctrl and select columns in Windows. How do I select 2 (multiple) columns in Excel on Mac? (Even if I run Excel in Fusion, the ctrl key still doesn't work!)

    One more question... Why is my NTFS external hard drive read only? What can I do in order to make changes/copy files to my external hard drive?
     
  2. ergdegdeg Moderator emeritus

    ergdegdeg

    Joined:
    Oct 13, 2007
    #2
    In most cases, the CMD key does in Mac OSX what the CTRL key does in Windows. So to select more than one thing, hold down CMD (or shift).
     
  3. realchimera thread starter macrumors regular

    Joined:
    Aug 23, 2011
    Location:
    Boston
    #3
    No the command key doesn't work. If you hold command, you will scroll your excel workbook
    Mac is so stupid that it's trying to use command to replace ctrl to be different from windows, but it's not doing it consistently.

    What is the hell is "ctrl+D", "command+delete", "fn+delete"****?
    How pathetic it has so many delete combination keys, but doesn't even have a real delete key.

    And it doesn't even have "page up, down" keys either. Sometime it's "fn+ up/down", but sometimes it's just up/down key. So inconsistent.... No wonder it almost got washed out.
     
  4. gusmahler, Aug 24, 2011
    Last edited: Aug 24, 2011

    gusmahler macrumors member

    Joined:
    Mar 17, 2011
    #4
    Because Mac's can't write to NTFS drives. You need to reformat it as a Mac drive if you want to write to it. If you need to use the drive on a PC also, you need to reformat it as FAT32.

    ----------

    As was pointed out to you in your other thread, you got it backwards. MS copied from Apple and remapped Cmd to Ctrl because PC keyboards don't have a cmd key.

    FTR, the first Mac OS was released in January 1984 and the first version of Windows was released 20 months later, in November 1985.

    If you hate the Mac so much, I suggest you sell it. It's probably fairly new and you'll get a lot of your money back. It'll save you the trouble of going to a Mac forum and bashing Mac products.
     
  5. realchimera thread starter macrumors regular

    Joined:
    Aug 23, 2011
    Location:
    Boston
    #5
     
  6. Mal macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #6
    First, there's no need to hold the command key while you move your mouse, but if you select one column, then command-click to select the other column, it does indeed select them both.

    Secondly, you can simply install NTFS-3G on your computer in order to enable write capabilities to NTFS drives, and not have to use the outdated FAT32 file system.

    jW
     
  7. tjb1 macrumors 68000

    Joined:
    Aug 26, 2010
    Location:
    Pennsylvania, USA
    #7
    FAT32 works for both Mac and Windows, only limitation is a 4gb file size.
     
  8. blevins321 macrumors 68030

    Joined:
    Dec 24, 2010
    Location:
    Winnipeg, MB
    #8
    If you have Windows 7 and Snow Leopard up to date, you can format as ExFAT and have a dual-compatible file system with no storage limitation.
     
  9. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #9
    Hold the Command key and click on the column headings that you want to select.
    • Read/Write FAT32 from both native Windows and native Mac OS X.
      [*]Maximum file size: 4GB.
    • Maximum volume size: 2TB
    NTFS (Windows NT File System)
    • Read/Write NTFS from native Windows.
    • Read only NTFS from native Mac OS X
      [*]To Read/Write/Format NTFS from Mac OS X: Install NTFS-3G for Mac OS X (free)(may not work with Lion)
    • Some have reported problems using Tuxera (approx $36).
    • Many have had good results with Paragon (approx $20) (works with Lion)
    • Native NTFS support can be enabled in Snow Leopard and Lion, but is not advisable, due to instability.
    • AirPort Extreme (802.11n) and Time Capsule do not support NTFS
    • Maximum file size: 16 TB
    • Maximum volume size: 256TB
    HFS+ (Hierarchical File System, a.k.a. Mac OS Extended)
    • Read/Write HFS+ from native Mac OS X
    • Required for Time Machine or Carbon Copy Cloner or SuperDuper! backups of Mac internal hard drive.
      [*]To Read/Write HFS+ from Windows, Install MacDrive
      [*]To Read HFS+ (but not Write) from Windows, Install HFSExplorer
    • Maximum file size: 8EiB
    • Maximum volume size: 8EiB
    exFAT (FAT64)
    • Supported in Mac OS X only in 10.6.5 or later.
    • Not all Windows versions support exFAT. See disadvantages.
    • exFAT (Extended File Allocation Table)
    • AirPort Extreme (802.11n) and Time Capsule do not support exFAT
    • Maximum file size: 16 EiB
    • Maximum volume size: 64 ZiB
     
  10. realchimera thread starter macrumors regular

    Joined:
    Aug 23, 2011
    Location:
    Boston
    #10
    What are the snow leopard and lion? Are they different version of Mac operating system?
     
  11. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #11
  12. Darth.Titan macrumors 68030

    Darth.Titan

    Joined:
    Oct 31, 2007
    Location:
    Austin, TX
  13. gusmahler macrumors member

    Joined:
    Mar 17, 2011
    #13
    Snow Leopard is version 10.6.8

    Lion is version 10.7.1

    If you bought your Mac new fairly recently, it probably has Lion.

    Follow these instructions to find out what version you have:

    http://www.apple.com/support/mobileme/en/os_version.html
     
  14. realchimera thread starter macrumors regular

    Joined:
    Aug 23, 2011
    Location:
    Boston
    #14
    Cool Thanks!

    A few more questions:

    1) What's the best/good program to r/w NTFS hard drive? Is it Paragon?

    2) Is there a hotkey to close a window/program, like alt+F4 in windows?

    3) How do you maximize a window other than clicking that tiny little green+ icon?
     
  15. gusmahler macrumors member

    Joined:
    Mar 17, 2011
    #15
    1) Don't know

    2) Cmd-Q

    3) click and drag the bottom right corner to resize. But hitting the green button is faster.
     
  16. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #16
    Did you see my earlier post with the information on the various formats and how to read/write to them? That answers your question.
    To close a window, use Command-W. (That doesn't quit multi-window apps)
    To quit an app, use Command-Q.
    Windows don't maximize on Mac the way they do on Windows. The green button won't make the app fill the screen. It resizes the window to accommodate its contents. Lion has introduced full screen capabilities, but it's still not exactly the same as Windows.
    That's not true. Macs can write to NTFS using one of several methods described in my earlier post. Reformatting to FAT32 is not necessary.
     
  17. realchimera thread starter macrumors regular

    Joined:
    Aug 23, 2011
    Location:
    Boston
    #17
    Paragon NTFS is awesome, so are you guys. One more question, is there a program that can let me customize the keyboard and create my own hotkeys?
     
  18. Daffodil macrumors 6502

    Daffodil

    Joined:
    Jun 7, 2011
    Location:
    In a sunny state of mind
    #18
    You can set up/change keyboard shortcuts if you go to System Preferences>Keyboard>Keyboard Shortcuts.
     

Share This Page