Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to Columns wizard greyed out
I need to use the Text to Columns Wizard - but it is greyed out on the Data
Tab. Any suggestions please? |
#2
|
|||
|
|||
Answer: Text to Columns wizard greyed out
If the Text to Columns Wizard is greyed out on the Data Tab, it could be due to a few reasons. Here are some possible solutions:
I hope these suggestions help you enable the Text to Columns Wizard. Let me know if you have any other questions or concerns.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to Columns wizard greyed out
On Aug 21, 10:47 am, vic1 wrote:
I need to use the Text to Columns Wizard - but it is greyed out on the Data Tab. Any suggestions please? Unprotect the worksheet, perhaps. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to Columns wizard greyed out
Perhaps your worksheet is protected?
-- David Biddulph "vic1" wrote in message ... I need to use the Text to Columns Wizard - but it is greyed out on the Data Tab. Any suggestions please? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to Columns wizard greyed out
Do you have more than one sheet selected?
Gord Dibben MS Excel MVP On Thu, 21 Aug 2008 08:47:01 -0700, vic1 wrote: I need to use the Text to Columns Wizard - but it is greyed out on the Data Tab. Any suggestions please? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to Columns wizard greyed out
It wasn't prtected - but it was shared. I copied the data to a new workbook
and it solved the problem. Thanks for your suggestions. "Gord Dibben" wrote: Do you have more than one sheet selected? Gord Dibben MS Excel MVP On Thu, 21 Aug 2008 08:47:01 -0700, vic1 wrote: I need to use the Text to Columns Wizard - but it is greyed out on the Data Tab. Any suggestions please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Why is the chart wizard greyed out on some of my Excel spreadsheet | Charts and Charting in Excel | |||
Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) |