Month: March 2019

Πώς Να Δείτε, Εισάγετε ή Επεξεργαστείτε Αλλαγές Σελίδων Στο Excel

Posted on

How To View, Insert or Edit Page Breaks in Excel

Οι Αλλαγές Σελίδων (Page Breaks) είναι διαχωριστικά που χωρίζουν το Φύλλο Εργασίας (Worksheet) σε διάφορες Σελίδες (Pages) για εκτύπωση. Στο Excel, οι Αυτόματες Αλλαγές Σελίδων (Automatic Page Breaks) έχουν εισαχθεί ανάλογα με το Μέγεθος Σελίδας (Paper Size), Ρυθμίσεις Περιθωρίων (Margin Settings), Επιλογές Κλιμάκωσης (Scale Options) και από τις θέσεις των Αυτόματων Αλλαγών Σελίδων (Manual Page Breaks) που έχουμε εισάγει. Εάν θέλουμε να Εκτυπώσουμε (Print) το Φύλλο Εργασίας (Worksheet) με το ακριβή αριθμό Σελίδων (Pages) που θέλουμε, θα πρέπει να ρυθμίσουμε τις Αλλαγές Σελίδων (Page Breaks) στο Φύλλο Εργασίας (Worksheet) πριν δώσουμε την εντολή. Για να δούμε λοιπόν πώς γίνεται, απλώς συνεχίστε να διαβάζετε την παρακάτω ανάρτηση.

Εισαγωγή-Διαγραφή-Αναθεώρηση Αλλαγών Σελίδων Στο Excel

Read the rest of this entry »

How To View, Insert or Edit Page Breaks in Excel

Posted on

Page Breaks are dividers that separate our Worksheet into different pages for printing. In Excel, automatic Page Breaks are inserted depending on the Paper Size, Margin Settings, Scale Options and the positions of the Manual Page Breaks that we have inserted. If we want to Print a Worksheet with the exact number of Pages that we want, we must adjust the Page Breaks in our Worksheet before we print it. To find out, how it is done, just keep on reading the post below.

Insert - Delete - Review Page Breaks in Excel

We must select the View tab, and then from the left area of the ribbon we locate the area named Workbook Views as shown in the image below.

View Tab - Workbook Views - Page Break Preview

Once we locate the Workbook Views area, we select the command Page Break Preview, where we will be able to See Where The Page Breaks Will Appear When Our Document Is Printed.

Page Break Preview

In the image below, I have selected the Page Break Preview, where we can see the actual page that will be printed when we decide to. We notice the Page 1 lettering in the middle of the Spreadsheet (which will not be printed) and we notice a Horizontal and Vertical Blue Line which define where the Page ends. The Horizontal and Vertical Blue Line defines a Manual Page Break that we have inserted.

Page Break Preview

If we need to adjust the Page Break manually, all we need to do is to click and select either the Horizontal or Vertical Line, or where the lines intersect at the bottom right corner and then drag them with our mouse to the position needed as shown in the image below.

Page Break Preview

Once we have dragged the lines to the position needed, we notice now that we have four (4) Pages in our Spreadsheet. We also notice that the Pages order goes from Top to Bottom and then from Left to Right, a feature that can be changed and will be described in a future post of mine. We also notice that we have besides the Straight Blue Lines (both vertical and horizontal), Dotted Blue Lines Vertical and Horizontal. The Dotted Blue Lines Vertical and Horizontal means that they are Automatic Page Breaks.

Page Break Preview

If we want to Insert our own Page Breaks and not to use the Automatic ones, we must select the Page Layout tab and then locate the area of the ribbon named Page Setup as shown in the image below.

Page Layout Tab - Page Setup Area

Once we have located the Page Setup area of the Page Layout tab, we select the command Breaks as shown in the image below. Once we select the command Breaks, from the drop-down menu that appears we have the following commands available and which are:

  • Insert Page Break: A Page Break will be inserted depending which is the activated Cell in our Spreadsheet.
  • Remove Page Break: The Manual Page Break that was inserted will be removed.
  • Reset All Page Breaks: All the Manual Page Breaks will be removed and only the automatic page breaks will be displayed.

If we want to Insert a Vertical Page Break, we must select the Row below where we want the Page Break to be Inserted.

If we want to Insert a Horizontal Page Break, we must select the Column to the right of where we want the Page Break to be Inserted.

Page Setup - Insert Breaks

Another way to Insert a Page Break in our Spreadsheet, we just activate the Cell needed and then do a right click with our mouse. From the shortcut menu that appears we select the command Insert Page Break as shown in the image below.

Insert Page Break Short Cut Menu

The procedure is quite easy and simple for us to Insert Page Breaks in Excel. When we open our Worksheet or an entire Workbook in Excel, we are not able to see where the pages begin and where they end. All we see are the Cells that are part of the Spreadsheet. As mentioned, for us to see the Page Breaks we must locate the Workbook Views area, and then select the command Page Break Preview

Below you can check out the video describing How To View, Insert or Edit Page Breaks in Excel.

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

Πώς Να Αντιγράψουμε ή Να Μετακινήσουμε Ένα Φύλλο Εργασίας του Excel

Posted on

How To Copy or Move A Worksheet in Excel?

Στο Excel, έχουμε τη δυνατότητα να Μετακινήσουμε (Move) ή να Αντιγράψουμε (Copy) ένα Φύλλο Εργασίας (Worksheet) μέσα στο ίδιο Βιβλίο Εργασίας (Workbook) έτσι ώστε να οργανώσουμε με τον τρόπο που θέλουμε το Βιβλίο Εργασίας (Workbook). Μπορούμε επίσης να Μετακινήσουμε (Move) ή να Αντιγράψουμε (Copy) ένα Φύλλο Εργασίας (Worksheet) σε άλλες θέσεις, όπως ένα ήδη ανοιχτό Βιβλίο Εργασίας (Workbook) ή σε ένα Νέο Βιβλίο Εργασίας (Workbook). Το μόνο που χρειάζεστε να κάνετε είναι να συνεχίστε να διαβάζετε την παρακάτω ανάρτηση.

Πώς Να Αντγράψτε ή να Μετακινήστε Φύλλα Εργασίας Στο Excel

Read the rest of this entry »

How To Copy or Move A Worksheet in Excel?

Posted on

In Excel, we can Move or Copy a Worksheet in the same Workbook so we can organize the Workbook the way we want to, or we can even Move or Copy a Worksheet to other location, such as an existing open Workbook or to a New Workbook. All you need to do, so you can find out how, is to continue reading this post below.

How To Move Or Copy A Spreadsheet in Excel

Read the rest of this entry »

Πώς Να Κάνουμε Διαγραφή Κελιών, Γραμμών, Στηλών και Φύλλων Εργασίας Στο Excel;

Posted on

How To Delete Cells, Rows, Columns and Spreadsheets in an Excel Workbook?

Σε προηγούμενη ανάρτησή μου, αναφέρθηκα πώς κάνουμε Εισαγωγή Κελιού, Κελιών, Γραμμής, Γραμμών, Στήλης, Στηλών, Φύλλου και Φύλλων Εργασίας σε ένα Βιβλίο Εργασίας του Excel (To Insert Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook). Τι συμβαίνει όμως, όταν φτάσουμε στο σημείο να θέλουμε να κάνουμε Διαγραφή Κελιού, Κελιών, Γραμμής, Γραμμών, Στήλης, Στηλών, Φύλλου και Φύλλων Εργασίας σε ένα Βιβλίο Εργασίας του Excel; (Delete Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook). Το μόνο που χρειάζεστε να κάνετε είναι να διαβάστε την παρακάτω ανάρτηση.

Διαγραφή Κελιών, Γραμμών, Στηλών & Φύλλων Εργασίας Στο Excel

Read the rest of this entry »

Πώς Να Εισάγουμε Κελιά, Γραμμές, Στήλες και Φύλλα Εργασίας Σε Ένα Βιβλίο Εργασίας του Excel

Posted on

How To Insert Cells, Rows, Columns and Spreadsheets in an Excel Workbook

Όλοι μας σε κάποια στιγμή όταν δουλεύουμε σε ένα Βιβλίο Εργασίας του Excel (Workbook), θέλουμε να Εισάγουμε ένα Κελί (Cell), Κελιά (Cells), ή θέλουμε να Εισάγουμε (Insert) Γραμμή (Row), Γραμμές (Rows), Στήλη (Column), Στήλες (Columns) ή ακόμα και ολόκληρο Φύλλο Εργασίας (Worksheet). Πώς γίνεται; Η διαδικασία είναι αρκετά απλή και γρήγορη, οπότε δεν χρειάζεται να ανησυχούμε εάν έχουμε ξεχάσει να εισάγουμε κάποια δεδομένα όταν δεν υπάρχει διαθέσιμος χώρος. Απλώς συνεχίστε να διαβάζεται την παρακάτω ανάρτηση.

Εισαγωγή Κελιών, Γραμμών, Στηλών & Φύλλων Εργασίας Στο Excel

Read the rest of this entry »

How To Insert Cells, Rows, Columns and Spreadsheets in an Excel Workbook?

Posted on

We have all come to a point when we are working in an Excel Workbook, where we need to Insert a Cell or Cells, or we need to Insert a Row, Rows or Column, Columns or even to Insert an entire Worksheet. How is it done? The procedure is quite simple and very handy, so we don’t need to worry if we have forgotten to insert some data and there is not enough space for us. Just keep on reading the post below.

How To Insert Cells, Rows, Columns & Sheets in Excel

For us to Insert Cells in a Spreadsheet, we must select the area of Cells that we need to Insert as shown in the image below. The number of Cells selected, the same amount will be Inserted in our Spreadsheet.

Cells Area on the Home Tab

Once the area of Cells is selected, there are two ways to Insert Cells. The first one, is to do a right click with our mouse on top of the selected area, and then from the shortcut menu that appears, we select the command Insert as shown below.

Insert Cells ShortCut Menu

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Insert and from the drop-down menu we select the command Insert Cells.

Insert Cells

When we choose to Insert Cells, new Rows will be added above of the selection and new Columns will be added to the left of the selection. Whatever way we choose, the same dialog box will appear which is named Insert, where we have the following options to choose from:

  • Shift Cells Right
  • Shift Cells Left
  • Entire Row
  • Entire Column

Insert Cells Dialog Box

For us to Insert Rows in a Spreadsheet, we must select the number of Rows that we want to Insert. When we Insert Rows, the same number of Rows selected will be inserted of the top of the selected Rows. The first way to Insert Rows, is to do a right click with our mouse on top of the selected Rows and then from the shortcut menu that appears we select the command Insert.

Insert Rows

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Insert and from the drop-down menu we select the command Insert Sheet Rows. As mentioned above, the same number of selected Rows will be Inserted above the selection.

Insert Sheet Rows

For us to Insert Columns in a Spreadsheet, we must select the number of Columns that we want to Insert. When we Insert Columns, the same number of Columns selected will be inserted at the left of the selected Columns. The first way to Insert Columns, is to do a right click with our mouse on top of the selected Columns and then from the shortcut menu that appears we select the command Insert.

Insert Columns

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Insert and from the drop-down menu we select the command Insert Sheet Columns. As mentioned above, the same number of selected Columns will be Inserted at the left of the selection.

Insert Sheet Columns

For us to Insert a Spreadsheet in our Workbook, the first way is to move on top of a Sheet that already exists in our Workbook, and then do a right click with our mouse. Whenever we Insert a Spreadsheet in our Workbook, the Spreadsheet will be inserted at the left of the selected Spreadsheet. From the shortcut menu that appears we select the command Insert as shown in the image below.

Insert Sheet

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Insert and from the drop-down menu we select the command Insert Sheet. As mentioned above, the Spreadsheet will be Inserted at the left of the selected Sheet.

Insert Sheet

Whatever way we choose, the same dialog box will appear which is named Insert, where we have the following options to choose from so, we can Insert a Sheet in our Workbook:

Worksheet, Chart, MS Excel 4.0 Macro, International Macro Sheet, MS Excel 5.0 Dialog and many more. We select the Sheet that we want and need to Insert and the press the Ok button located at the bottom right corner of the Insert dialog box.

Insert Spreadsheet Dialog Box

Below you can check out the video describing How To Insert Cells, Rows, Columns and Spreadsheets in an Excel Workbook.

Don’t Forget to Subscribe To My YouTube Channel.

YouTube Channel