Select part of a text that exists already in an above cell

Posted by pragadheesh on Super User See other posts from Super User or by pragadheesh
Published on 2010-03-29T07:00:20Z Indexed on 2010/03/29 12:03 UTC
Read the original article Hit count: 304

Filed under:

excel-2003

|

keyboard-shortcuts

|

autocomplete

How do I get Excel to partially auto-complete a word using another that already exist in the same worksheet?

Let's say I have the word "Microsoft" in a cell and in the cell below I want to type the word "Microhard".

When I start typing Microhard, the word Microsoft appears shaded in black.

How can I select the "Micro" part alone from Microsoft and continue to fill out the rest with "hard" without it trying to fill out as Microsoft?

© Super User or respective owner

Related posts about excel-2003

Migrating from VBA Excel 2003

as seen on Super User - Search for 'Super User'
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in… >>> More
Migrating from VBA Excel 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in… >>> More
Excel: how to add cells to named range

as seen on Super User - Search for 'Super User'
I have a named range for 3 cells in excel 2003 I need to insert 1 more cell into this named range how do I achieve this in excel 2003 >>> More
How to stop Excel 2003 from loading a Gazillion files

as seen on Super User - Search for 'Super User'
One of my soon-to-be-ex-friends got an Excel file from another friend of his and decided to click on it. It started opening all kinds of files from within Excel. Over 200 and still counting when he called me. I told him to go to task manager, which showed a LOT of files in the applications tab, but… >>> More
Create or Open an .xlsx file having >256 columns in MS Excel 2003

as seen on Super User - Search for 'Super User'
I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx). Now given that I have installed Compatibility pack, can I create or open a Microsoft Excel 2007 file (.xlsx) having more… >>> More

Related posts about keyboard-shortcuts

Useful Excel keyboard shortcuts

as seen on Super User - Search for 'Super User'
What keyboard shortcuts do you use in Excel? Things I've discovered recently and found very useful are: Shift + Space - select the current row Ctrl + Space - select the current column Ctrl + Shift + Space - select the block of contiguous cell Ctrl + + - Insert (as in the context menu). If the current… >>> More
Configure different set of keyboard shortcuts for copy/paste in Photoshop

as seen on Super User - Search for 'Super User'
Being left-handed, I use the mouse in my left hand. In most applications I use Ctrl + Insert or Shift + Insert to copy and paste (with my right hand). For some bone-headed reason, this is not supported in Photoshop, so I have to use right-click Copy sub-menus, which is a lot slower. Is there a… >>> More
Visual studio keyboard shortcuts cheat sheet - desktop size

as seen on Stack Overflow - Search for 'Stack Overflow'
OK - this is pretty specific, i'm looking for a cheat sheet for visual studio keyboard shortcuts that I can set as my desktop bg. so, something in a modest 1280 x 1024. Something like this; http://www.microsoft.com/downloads/details.aspx?FamilyID=c15d210d-a926-46a8-a586-31f8a2e576fe&DisplayLang=en but… >>> More
SSMS - Please get keyboard shortcuts working for schemas

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
My current client is using schemas which is good as it provides nice seperation. However it causes me pain on a daily basis. The reason. I can't use the built in keyboard shortcuts in SQL Server management studio. I can't believe how painfully annoying this is. It's just madness that… >>> More
What causes my keyboard shortcuts to be disabled on startup?

as seen on Super User - Search for 'Super User'
Hi all, I'm using latest Karmic Koala 9.10. I upgraded from 9.04, whenever I reboot I have to go to System - Preferences - Keyboard Shortcuts, and just opening it will allow me to use my keyboard shortcuts once again. What daemon is being run by the System - Preferences - Keyboard Shortcuts link… >>> More