ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   complete blank cells (https://www.excelbanter.com/excel-worksheet-functions/183570-complete-blank-cells.html)

Mery[_2_]

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

ryguy7272

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


Mery[_2_]

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!


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com