I have no earthy idea why it took me so long to figure out how to delete the contents of a cell or range in Excel for Mac. Ever since I bought my MacBook Pro I've known the Delete key on a Mac isn't really a Delete key.
I mean, since my background is with Windows, I have ingrained knowledge on how the Delete Key works on a computer. Ingrained, I tell you.
Start quickly with the most recent versions of Word, Excel, PowerPoint, Outlook, OneNote and OneDrive —combining the familiarity of Office and the unique Mac features you love. Work online or offline, on your own or with others in real time—whatever works for what you're doing. What is an easy video editing software.
- With Excel, your Office moves with you and can implement the most complex formulas, with amazing features. Highlights: Unmistakably Office, designed for Mac - MacBook Pro Touch Bar is fully supported by Microsoft Excel. If you type an equals sign into a cell, Excel will immediately pull up the most recently used functions in the Touch Bar.
- This article was written by Travis Boylls.Travis Boylls is a Technology Writer and Editor for wikiHow. Travis has experience writing technology-related articles, providing software customer service, and in graphic design.
But all of that knowledge was shattered upon getting a Mac.
Where Is the Excel Delete Button on Mac
After some consternation, I learned where is the delete button on a Mac. To press the delete button on Mac computers you have to hold down the fn key and the Delete key at the same time when you want to delete something on a Mac. (Skip to video)
After a while, you get used to the idea that the Delete key on a Mac is really a backspace key and using fn+Delete gives you the real Delete key action. 🙂
Of course if you're a long time Mac user you probably think I'm cuckoo. But hey, this is my blog, think what you like. I'm not the only one who's decided to start using a Mac after a lifetime of Windows abuse use. Paint net alternative mac.
Excel for Mac
Anyway, when using Excel on a Mac — I've got versions 2008 and 2011 — you run into a learning curve with all the unusual shortcut keys, function keys (1, 2), and menu and ribbon things that are different from the Windows version of Excel. So there's a tendency to forget about how the Delete key works on a Mac.
Office 2016 pro mac. Pdf mac os x. I mean, this is Excel we're talking about here. Hitting the Delete key is supposed to delete the contents of the active cell, for cryin' out loud.
In Excel for Mac it does that, but the cursor also gets stuck inside the cell in edit mode. You have to hit the enter key to finish deleting the contents, but this act also moves the active cell to the next cell down.
And if you've selected a range and hit the Delete key, the active cell contents are deleted and the cursor is stuck inside the cell in edit mode. You have to hit the Enter key, which does nothing but take you to the next cell. The range contents are still there, with the exception of the active cell.
Not the kind of behavior that occurs in Excel for Windows.
How to Delete Cell and Range Contents in Excel for Mac
The trick is to remember that fn+Delete is really a keyboard shortcut to the Delete key on a Mac. Then the world rights itself and the planets align. Frustration abates. You've finally found the magic. Your mojo is back!
Watch this 54 second video to see what I've been babbling about for the past 454 words.
Where Is the Excel Delete Button on Mac
After some consternation, I learned where is the delete button on a Mac. To press the delete button on Mac computers you have to hold down the fn key and the Delete key at the same time when you want to delete something on a Mac. (Skip to video)
After a while, you get used to the idea that the Delete key on a Mac is really a backspace key and using fn+Delete gives you the real Delete key action. 🙂
Of course if you're a long time Mac user you probably think I'm cuckoo. But hey, this is my blog, think what you like. I'm not the only one who's decided to start using a Mac after a lifetime of Windows abuse use. Paint net alternative mac.
Excel for Mac
Anyway, when using Excel on a Mac — I've got versions 2008 and 2011 — you run into a learning curve with all the unusual shortcut keys, function keys (1, 2), and menu and ribbon things that are different from the Windows version of Excel. So there's a tendency to forget about how the Delete key works on a Mac.
Office 2016 pro mac. Pdf mac os x. I mean, this is Excel we're talking about here. Hitting the Delete key is supposed to delete the contents of the active cell, for cryin' out loud.
In Excel for Mac it does that, but the cursor also gets stuck inside the cell in edit mode. You have to hit the enter key to finish deleting the contents, but this act also moves the active cell to the next cell down.
And if you've selected a range and hit the Delete key, the active cell contents are deleted and the cursor is stuck inside the cell in edit mode. You have to hit the Enter key, which does nothing but take you to the next cell. The range contents are still there, with the exception of the active cell.
Not the kind of behavior that occurs in Excel for Windows.
How to Delete Cell and Range Contents in Excel for Mac
The trick is to remember that fn+Delete is really a keyboard shortcut to the Delete key on a Mac. Then the world rights itself and the planets align. Frustration abates. You've finally found the magic. Your mojo is back!
Watch this 54 second video to see what I've been babbling about for the past 454 words.
Related posts:
- Advertisement
- NPlayer v.1.0IMPORTANT: I've moved this project to http://code.google.com/p/nplayer/ so please update your links. A D20 RolePlayingGame Java engine with a Graphical User Interface, aiming at granting a Dungeon Master maximum control over gameplay to meet most .
- InDesign Automator Action Pack for Leopard for Mac OS v.3.01This action pack extends the power of Automator in Leopard with 20 actions for use with Adobe InDesign!- Add Pages to InDesign Documents- Close InDesign Documents- Export InDesign Documents to PDF- Find and Change Text in InDesign Documents- .
- Microsoft Office 2001 for Mac Security Update v.9.0.6This update addresses several buffer overrun vulnerabilities in Microsoft Word, Excel, PowerPoint, and Entourage for Office 2001. It also addresses an issue affecting the display of Japanese characters placed in the header or footer of an Excel .
- Invoice Template for Excel v.3.0The invoice template for Excel is a complete customer invoicing system with ability to store created invoices, products and customer details, manage inventory and perform advanced order sales reporting.
- (yX) for Excel for Mac OS v.2.2A knowledge mining tool that works with data stored in Microsoft Excel for building predictive and descriptive models from this data autonomously and easily. It supports both major releases of Microsoft Excel, 2004 and 2008. The modeling engine of .
- Business Valuation Model Excel v.2.1.2The Business Valuation Model Excel is an 'out-of-the-box' professional valuation model developed by a CFA charterholder. It is designed to accept information from publicly-available 10-K reports in order to calculate the total and per-share value of .
- No-IP Dynamic DNS Update Client (DUC) for Mac OS v.3.1.3bSits in the background and monitors your current WAN IP address and updates the DNS associated with your No-IP account when your IP address changes. Update multiple hosts asscociated with your account. Simply select which hosts in your account you .
- Excel Gantt Chart Template Deluxe v.2.6.3Excel Gantt Chart Template - Create Gantt Charts in ExcelThe Excel Gantt Chart Template Deluxe Edition makes it easy to create professional-looking Gantt charts in Excel.Three separate Excel Gantt chart templates are included with your .
- Excel File Merger v.1.1Excel File Merger is a nifty application for Apple Macintosh (Mac OS X, Jaguar, Panther, Tiger and Leopard) which easily and efficiently batch merges or combines hundreds or thousands of Excel (xls), Text (txt), or Comma separated value (CSV) files .
- Aiseesoft Mac PDF to Excel Converter v.3.2.26Aiseesoft Mac PDF to Excel Converter can help users easily to convert almost all PDF document to Excel format on Mac. It also supports OCR technology which can recognize text from the scanned PDF documents and convert it to text-based excel files.
- Balance Sheet Template for Excel v.2.0Basic and common-size balance sheet template for Excel.
- Income Statement Template for Excel v.2.0Basic and common-size income statement template for Excel.
- Diet Calculator for Excel v.2.0Diet software for Excel, customized for your body, diet and exercise habits.
- Checkbook Register for Excel v.2.0Manage your checkbook in Excel.
- Loan Calculator for Excel v.2.0Analyze loan amortization in Excel.
- Monthly Home Budget Worksheet for Excel v.2.0Set up and manage your budget in Excel.
- Excel Data Recovery v.latestMS Excel Recovery Software is a reliable, compatible and competent tool to restore the files lost due to corruption in the MS Excel.
- Schedule Multiple Daily Tasks for Your Employees with Excel v.7.6Excel spreadsheet to assign multiple daily tasks to 20 employees. Integrates with QuickBooks Pro for payroll and client billing. Comes in sizes for 20, 40, 60, 80, 120 and 160 employees.
- Adobe After Effects plugin update v.1.0The Adobe After Effects 6.0 Plug-in update fixes problems in the Radial Wipe effect and in OpenGL shadows on Mac OS X v.10.3. Note: The After Effects 6.0 Plug-in update will modify only After Effects 6.0 Standard or Professional. It will work with .
- Adobe Photoshop CS MultiProcessor Support updateAdobe Photoshop CS MultiProcessor Support update is a plug-in for Adobe Photoshop CS to solve the problem that caused image corruption when rotating bitmap images and an issue that caused a program error when using the Magic Wand .
How To Update Excel Version
- Microsoft Office 2001 for Mac Security Update This update addresses several buffer overrun
- Excel Gantt Chart Template Deluxe Excel Gantt Chart Template - Create Gantt Charts in Excel
- Business Valuation Model Excel The Business Valuation Model Excel is an 'out-of-the-box'
- (yX) for Excel for Mac OS A knowledge mining tool that works with data stored in
- Invoice Template for Excel The invoice template for Excel is a complete customer
- Aiseesoft Mac PDF to Excel Converter Aiseesoft Mac PDF to Excel Converter can help users easily
- BBEdit Update BBEdit Update 7.1.4 is a tool for HTML programmers and
- No-IP Dynamic DNS Update Client (DUC) for Mac Sits in the background and monitors your current WAN IP
- Balance Sheet Template for Excel Basic and common-size balance sheet template for Excel .
- Photoshop Keyboard Shortcut Fix update Photoshop Keyboard Shortcut Fix update is an update
Microsoft Excel For Mac
Visit HotFiles@Winsite for more of the top downloads here at WinSite!