Results 1 to 4 of 4
Hybrid View
-
1st June 2014 18:06 #1Registered User
Join Date: Jan:2008
Location: kokidj 22
Posts: 7
Êàê å íàïðàâåí òîçè ôîðìàò â åêñåë?
Àêî ìîæå íÿêîé äà îáÿñíè êàê å ïîñòèãíàò òîçè ôîðìàò êîíêðåòíî ñòàâà äóìà çà :
-êàê òàêà èìà êëåòêè êîèòî íå ìîæå äà ñå ìàðêèðàò
-êàê å íàïðàâåíî òàêà,÷å â ëèñò INVOICE å îãðàíè÷åí áðîÿ íà êîëîíèòå îò À äî J è ðåäîâå îò 1 äî 57
Àêî íÿêîé çíàå ùå ñúì áëàãîäàðåí äà ìè ïîìîãíå
-
1st June 2014 23:47 #2Registered User
Join Date: Oct:2012
Location: Earth
Posts: 640
Protect cells
Protect sheet
Hide cells (ìàðêèðàø äî êðàÿ ñ "Ctrl+Shift+äÿñíà ñòðåëêà")
-
2nd June 2014 10:11 #3Registered User
Join Date: Jan:2008
Location: kokidj 22
Posts: 7
íåùî íå ìîãà äà ñõâàíà òî÷íî êàê ñòàâà
-
12th June 2014 09:20 #4Registered User
Join Date: Oct:2012
Location: Earth
Posts: 640
Èçâèíÿâàì ñå! Âúîáùå çàáðàâèõ, ÷å ñúì ïèñàë â òàçè òåìà, àìà ïúê è òè ìîæåøå äà ÷óêíåø åäèí Ãóãëüî ñ êîìàíäèòå, êîèòî ïîñî÷èõ.
Hide cells
1. Ìàðêèðàø öÿëà êîëîíà (ïðèìåðíî J)
2. Íàòèñêàø Shift+Ctrl+äÿñíà ñòðåëêà. Âñè÷êè êîëîíè äî êðàÿ ñå ìàðêèðàò.
3. Äåñåí áóòîí -> Hide
Ïî ñúùèÿ íà÷èí ñ ðåäîâåòå - ìàðêèðàø öÿë ðåä (ïðèìåðíî 58-ìè), Shift+Ctrl+äîëíà ñòðåëêà è ïîñëå ãè ñêðèâàø.
Protect cells
1. Ïèøåø, êàêâîòî ïèøåø
2. Ìàðêèðàø êëåòêèòå, êîèòî æåëàåø
3. Äåñåí áóòîí -> Format cell -> Protection -> èçáèðàø Locked
4. Îò ìåíþòî ãîðå -> Review -> Protect sheet -> èçáèðàø îïöèèòå, êîèòî æåëàåø.
Âïðî÷åì òîçè ôàéë, êîéòî ñè ïîñî÷èë íå å çàùèòåí ñ ïàðîëà è ìîæåø äà íàòèñíåø Review -> Unprotect sheet, çà äà âèäèø êàê ðàáîòè.




Reply With Quote
Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð