Fixed-width Text to Columns without using mouse?

Auracle

New Member
Joined
Apr 18, 2011
Messages
19
Heyyyya folks!

Been a while since I've been here, but I've been trying to find some information and not having any luck, so....here I be! :)

I'm one of those people who loves keyboard shortcuts more than using the mouse, as a general rule. I use the Text to Column function on a regular basis, both for Delimited and Fixed Width splits.

I can do the Delimited splits just fine using only the keyboard, but it doesn't seem like there is a way to use the keyboard to add/remove/change the break lines when you are doing a Fixed Width split. It looks like perhaps there should be some method - the "Data preview" window shows an underline under the 'p' in 'preview', as if you can use the ALT+P to move to that section... but I've never been able to do anything in that section with the keyboard.

Does anyone here know if there is any way to manipulate the break lines with the keyboard (aside from using a macro)? I imagine that's got to be a real pain in the hind end for those who have difficulty with or can't use a mouse if there isn't a way :/

Thank you!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top