Then you could move the highlight region around with arrow keys and such. In Lotus 1-2-3, you first highlighted a range and then tapped the dot/period key (.). So then, are there any Excel shortcuts to define new ranges in blank areas of your worksheet? Really big ranges should be highlighted with keyboard shortcuts like those discussed here.Terribly inefficient to use a mouse.
Done.Įxcept that it doesn’t work so well with ranges that are very large and can’t be viewed all at once on the screen. Click and drag to highlight what you want. If you’re using a mouse it’s dead simple. Maybe a single formula is to be copied to a matrix of various rows and columns, say. Sometimes we need to copy the contents of a filled range to a blank area - but the new range will be of a different size. Highly doubtful that it exists in Excel but it never hurts to ask. įor many year’s I’ve been hoping to find a particular keyboard shortcut.
I think the first advanced GUI I saw was either Microsoft Word or Excel. I just use them to put my computer to sleep, or to change what happens when I start the computer, e.g., to enter the BIOS/UEFI setup, or to temporary change the boot order.īesides WordPerfect, there was a database program called dBase. I suppose this was much better than a GUI if that is what you mainly used, but a GUI is much better for non-experts.
#MAKE TABLE IN EXCEL FOR MAC WINDOWS#
They didn’t have a Windows key back then. Each key could do multiple functions, depending on what key was pressed along with it (e.g., control, fn, shift). I think WordPerfect had a little template that you laid down on top of the Function keys (above your number keys). If I recall correctly, most tasks were done with key combinations. In ancient days, like 30 years ago, I have a recollection the GUI interface was not as developed as today. You ask “Did computer users know and use keyboard shortcuts and other tricks more in the past? ” Here is a combination of shortcuts that will work all the time: use Ctrl-End to jump all the way down, then Home to jump to the first cell of that row, and then Ctrl-Up to the last cell of the table with data.
#MAKE TABLE IN EXCEL FOR MAC HOW TO#
This page will show you how to convert Excel data into a table.
0 kommentar(er)
