| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complete blank cells
itanje
I have some blank cells which have to be complete once. Example, same people have a keys, but all cells doesn't complete, 358 John John " 423 Mery Mery " Can somebody help to solve the problem, Thanks very much Mery |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
complete blank cells
I'm not exactly sure what you want to do, but give this a try.
Select your data range with your mouse, hit Ctrl + g, then click 'Special', click 'Blanks', Click OK, type the '=' sign, hit the up arrow key, hold down the Ctrl key and then hit enter. Regards, Ryan--- -- RyGuy "Mery" wrote: itanje I have some blank cells which have to be complete once. Example, same people have a keys, but all cells doesn't complete, 358 John John " 423 Mery Mery " Can somebody help to solve the problem, Thanks very much Mery |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
complete blank cells
Korisnik "ryguy7272" napisao je: I'm not exactly sure what you want to do, but give this a try. Select your data range with your mouse, hit Ctrl + g, then click 'Special', click 'Blanks', Click OK, type the '=' sign, hit the up arrow key, hold down the Ctrl key and then hit enter. Regards, Ryan--- -- RyGuy "Mery" wrote: itanje I have some blank cells which have to be complete once. Example, same people have a keys, but all cells doesn't complete, 358 John John " 423 Mery Mery " Can somebody help to solve the problem, Thanks very much Mery Thanks Ry Guy, you solved my problem! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complete blank cells | Excel Worksheet Functions | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Reference Cells from other Workbook to complete Formula | Excel Discussion (Misc queries) | |||
| how do i move a row of cells when they're fully complete? | Excel Worksheet Functions | |||
| Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
![Mery[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
