Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to restore worksheet's gridlines & attributes
dear all,
thank you for taking the time to respond to my query. i have copy pasted tables from web pages onto excel worksheets. there was no problem in retaining the characters and values, they were exactly the same on the worksheet as the web page tables. the problems a 1. the bold borders on the webpage tables were copied pasted as well. i got rid of this by highlighting the cells - borders toolbar buttons - remove borders. however, by doing so, i have also remove all the (grey) gridlines within the highlighted areas! my attempts at resolving this: a. i tried to use cut and paste special so that i can choose to cut and paste only values but the option cut and paste special was 'greyed-out' i.e. not available when i tried to redo the process by copying the table on the webpage and trying to cut and paste special 'values only' onto the worksheet. b. choosing apply borders from the toolbar border button, however this lead to, not surprisingly, borders being drawn. my question: is there a way to restore the gridlines in these situations? 2. the copy paste function unfortunately also copied the line-spacing such that, in this case, each line of entry was double-spaced. i could manually double-clicked on the row line for each row to remove the double-spacing but it would be very tedious to say the least. my question: is there a way to restore the horizontal gridlines to default setting (i.e. height 12.5, pixel:17)? thank you for taking the time to answer my queries and for help/advice. regards, jes |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to restore worksheet's gridlines & attributes
Have you tried the TOOLSOPTIONSVIEW checkmark Gridlines?
"xppuser" wrote: dear all, thank you for taking the time to respond to my query. i have copy pasted tables from web pages onto excel worksheets. there was no problem in retaining the characters and values, they were exactly the same on the worksheet as the web page tables. the problems a 1. the bold borders on the webpage tables were copied pasted as well. i got rid of this by highlighting the cells - borders toolbar buttons - remove borders. however, by doing so, i have also remove all the (grey) gridlines within the highlighted areas! my attempts at resolving this: a. i tried to use cut and paste special so that i can choose to cut and paste only values but the option cut and paste special was 'greyed-out' i.e. not available when i tried to redo the process by copying the table on the webpage and trying to cut and paste special 'values only' onto the worksheet. b. choosing apply borders from the toolbar border button, however this lead to, not surprisingly, borders being drawn. my question: is there a way to restore the gridlines in these situations? 2. the copy paste function unfortunately also copied the line-spacing such that, in this case, each line of entry was double-spaced. i could manually double-clicked on the row line for each row to remove the double-spacing but it would be very tedious to say the least. my question: is there a way to restore the horizontal gridlines to default setting (i.e. height 12.5, pixel:17)? thank you for taking the time to answer my queries and for help/advice. regards, jes |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to restore worksheet's gridlines & attributes
The gridlines will not show if the background color of the cells is "white"
which is usually the case with web page imports. Select the cells and FormatCellsPatternsNo Color To restore row heights to 12.75, select all by CTRL + a(twice in 2003) and FormatRowsHeight12.75 Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 02:40:02 -0800, "xppuser" wrote: dear all, thank you for taking the time to respond to my query. i have copy pasted tables from web pages onto excel worksheets. there was no problem in retaining the characters and values, they were exactly the same on the worksheet as the web page tables. the problems a 1. the bold borders on the webpage tables were copied pasted as well. i got rid of this by highlighting the cells - borders toolbar buttons - remove borders. however, by doing so, i have also remove all the (grey) gridlines within the highlighted areas! my attempts at resolving this: a. i tried to use cut and paste special so that i can choose to cut and paste only values but the option cut and paste special was 'greyed-out' i.e. not available when i tried to redo the process by copying the table on the webpage and trying to cut and paste special 'values only' onto the worksheet. b. choosing apply borders from the toolbar border button, however this lead to, not surprisingly, borders being drawn. my question: is there a way to restore the gridlines in these situations? 2. the copy paste function unfortunately also copied the line-spacing such that, in this case, each line of entry was double-spaced. i could manually double-clicked on the row line for each row to remove the double-spacing but it would be very tedious to say the least. my question: is there a way to restore the horizontal gridlines to default setting (i.e. height 12.5, pixel:17)? thank you for taking the time to answer my queries and for help/advice. regards, jes |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to restore worksheet's gridlines & attributes
Thank you to ufo_pilot and Gord Dibben for their advice:
1. ufo_pilot: the gridlines option was indeed ticked by default. 2. Gord Dibben: your suggestion worked! Just a minor note, for some reasons I only seem to need to press ctrl + a (once in Office 2003 and no need to be twice - to select all). Regards, jes "Gord Dibben" wrote: The gridlines will not show if the background color of the cells is "white" which is usually the case with web page imports. Select the cells and FormatCellsPatternsNo Color To restore row heights to 12.75, select all by CTRL + a(twice in 2003) and FormatRowsHeight12.75 Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 02:40:02 -0800, "xppuser" wrote: dear all, thank you for taking the time to respond to my query. i have copy pasted tables from web pages onto excel worksheets. there was no problem in retaining the characters and values, they were exactly the same on the worksheet as the web page tables. the problems a 1. the bold borders on the webpage tables were copied pasted as well. i got rid of this by highlighting the cells - borders toolbar buttons - remove borders. however, by doing so, i have also remove all the (grey) gridlines within the highlighted areas! my attempts at resolving this: a. i tried to use cut and paste special so that i can choose to cut and paste only values but the option cut and paste special was 'greyed-out' i.e. not available when i tried to redo the process by copying the table on the webpage and trying to cut and paste special 'values only' onto the worksheet. b. choosing apply borders from the toolbar border button, however this lead to, not surprisingly, borders being drawn. my question: is there a way to restore the gridlines in these situations? 2. the copy paste function unfortunately also copied the line-spacing such that, in this case, each line of entry was double-spaced. i could manually double-clicked on the row line for each row to remove the double-spacing but it would be very tedious to say the least. my question: is there a way to restore the horizontal gridlines to default setting (i.e. height 12.5, pixel:17)? thank you for taking the time to answer my queries and for help/advice. regards, jes |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to restore worksheet's gridlines & attributes
CTRL + a once works for me also, but some users need to do it twice so I add it
to any posting. I believe one of the service packs corrected the bug but not everyone has updated. Thanks for the feedback. Gord On Sat, 14 Jan 2006 00:40:02 -0800, "xppuser" wrote: Thank you to ufo_pilot and Gord Dibben for their advice: 1. ufo_pilot: the gridlines option was indeed ticked by default. 2. Gord Dibben: your suggestion worked! Just a minor note, for some reasons I only seem to need to press ctrl + a (once in Office 2003 and no need to be twice - to select all). Regards, jes "Gord Dibben" wrote: The gridlines will not show if the background color of the cells is "white" which is usually the case with web page imports. Select the cells and FormatCellsPatternsNo Color To restore row heights to 12.75, select all by CTRL + a(twice in 2003) and FormatRowsHeight12.75 Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 02:40:02 -0800, "xppuser" wrote: dear all, thank you for taking the time to respond to my query. i have copy pasted tables from web pages onto excel worksheets. there was no problem in retaining the characters and values, they were exactly the same on the worksheet as the web page tables. the problems a 1. the bold borders on the webpage tables were copied pasted as well. i got rid of this by highlighting the cells - borders toolbar buttons - remove borders. however, by doing so, i have also remove all the (grey) gridlines within the highlighted areas! my attempts at resolving this: a. i tried to use cut and paste special so that i can choose to cut and paste only values but the option cut and paste special was 'greyed-out' i.e. not available when i tried to redo the process by copying the table on the webpage and trying to cut and paste special 'values only' onto the worksheet. b. choosing apply borders from the toolbar border button, however this lead to, not surprisingly, borders being drawn. my question: is there a way to restore the gridlines in these situations? 2. the copy paste function unfortunately also copied the line-spacing such that, in this case, each line of entry was double-spaced. i could manually double-clicked on the row line for each row to remove the double-spacing but it would be very tedious to say the least. my question: is there a way to restore the horizontal gridlines to default setting (i.e. height 12.5, pixel:17)? thank you for taking the time to answer my queries and for help/advice. regards, jes Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
Restore Gridlines | Excel Discussion (Misc queries) | |||
How do you add gridlines? | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |