Results 1 to 4 of 4

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jan:2008
    Location: kokidj 22
    Posts: 7

    Êàê å íàïðàâåí òîçè ôîðìàò â åêñåë?

    Àêî ìîæå íÿêîé äà îáÿñíè êàê å ïîñòèãíàò òîçè ôîðìàò êîíêðåòíî ñòàâà äóìà çà :
    -êàê òàêà èìà êëåòêè êîèòî íå ìîæå äà ñå ìàðêèðàò
    -êàê å íàïðàâåíî òàêà,÷å â ëèñò INVOICE å îãðàíè÷åí áðîÿ íà êîëîíèòå îò À äî J è ðåäîâå îò 1 äî 57
    Àêî íÿêîé çíàå ùå ñúì áëàãîäàðåí äà ìè ïîìîãíå
    Attached Files

  2. #2
    Registered User
    Join Date: Oct:2012
    Location: Earth
    Posts: 640
    Protect cells
    Protect sheet
    Hide cells (ìàðêèðàø äî êðàÿ ñ "Ctrl+Shift+äÿñíà ñòðåëêà")

  3. #3
    Registered User
    Join Date: Jan:2008
    Location: kokidj 22
    Posts: 7
    íåùî íå ìîãà äà ñõâàíà òî÷íî êàê ñòàâà

  4. #4
    Registered 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, çà äà âèäèø êàê ðàáîòè.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè