yipolar.blogg.se

1. #Shortcut in excel for insert cells mac serial numbers#
2. #Shortcut in excel for insert cells mac windows#

You can also use CHAR(149) to add a bullet in a cell. If you want to add a dark dot for bullet points you can use Alt + 7 or if you want to add a circle, you can use alt + 9.

In symbol dialog box, you have a lot of smart symbols to use as a bullet point or you can simply use a black dot.Once you click on the symbol button, you’ll get a symbol dialog box.

Select the cell in which you want to add a bullet point.I am sure you have used this method before. Add a Bullet Point from Symbol Dialog Box So, today in this post, I’d like to share with you all those methods. A few days back I have realized that actually, we can use 8 different ways to insert bullet points in Excel.Īnd, all these methods can be useful in different situations. In Excel, there is no default way to insert a bullet point as we have in Microsoft Word.īut here is the good news. I mostly use bullet-point lists to capture my day-to-day work (To-do lists, Important points).

#Shortcut in excel for insert cells mac serial numbers#

In Excel, most of the time we use serial numbers but when you are working on lists the best way is to use bullet point. Those who like to use the mouse for everything and never use keyboard shortcuts (98% of the population) are oblivious to all of this, as they should be.Capturing data in the right way is important. Imagine if in a photo album application, where all of the photo thumbnails were displayed, after you were able to keyboard your way to a particular photo, you had to hit Command-O to open that photo? You’d go crazy! I’ve tried some photo applications like that, but I gave up on those quickly as they clearly didn’t understand the normal usage flow of their heavier users.Īgain, this is for the heavy super-users. Lastly, for anyone who lives by the keyboard, having to use two hands to manipulate the keyboard to select a file is highly highly inefficient, and THAT is truly retarded. So why would you have one usage be Command Open while the other is Enter? In this dialog, you don’t hit Command-O to select the file you want to open you hit Enter (or double click for those who don’t like to use the keyboard, but then, this thread shouldn’t be of any interest to you in the first place) to open the file. When you try to open a file with the context of an application like Word, Excel, or any other application, the application will pop open an instance of the File Chooser dialog box, which is actually just another view of Finder.

I understand to increase their sales, MS has to keep mucking with their Office Suite, but they do it at the expense of everyone else who’s bought it up to that point).Īctually, here’s the reason Finder’s default key mapping is “retarded”. I’ve got all of that junk turned off permanently, although in Redmond’s Apple-esque wisdom, there is a lot of functionality in the Ribbon that isn’t available in the pulldown menus.

#Shortcut in excel for insert cells mac windows#

(and don’t get me started about the ultra-retardation in the Windows ‘Ribbon’ recently. Which then means you can’t map Insert a Sheet to F10 or Insert Chart to Shift F10, which is the standard Windows Excel mapping. The one weird (though good, if you like it as so) aspect of doing so is that the volume/mute function keys will still work without hitting the Fn key together, which is a pain in the butt because you can’t use F10~F12 as standard keys. Given the number of times I actually change my screen brightness vs the number of times I have to edit a cell in Excel, it’s a worthy change. This means though you have to hit the Fn + F2/F3 keys to dim/brighten your screen etc. This will let you use the F2 key in Excel without dimming your screen. In your System Preferences / Keyboard / Keyboard, you’ll need to have the checkbox “Use all F1, F2, etc keys as standard function keys” checked. The way that you’ll have to get it to work is this: