After you have drawn the number of required lines, Press the “Esc” button.Įxample #3 – Draw an arrow in a flow diagram Step 3: Repeat “Step 2” for every line you need to draw. Step 2: Click anywhere in the document or the point from where you want to start, hold and drag your mouse pointer to a different location or the point where you want to end and then release the mouse cursor. Step 1: While selecting the type of line, right-click on the required type and select “Lock Drawing Mode” as shown below: Below are the steps that you need to follow to draw multiple lines repeatedly. To overcome this situation, Excel has an inbuilt functionality, i.e.
![hide print lines excel 2016 hide print lines excel 2016](https://www.lifewire.com/thmb/-1hfMYnKuwVaBAq_gfVhgbANYZI=/769x512/filters:no_upscale():max_bytes(150000):strip_icc()/gridlines-712c2f0e8e5a4cf5830547437f5895b4.jpg)
What if we need to draw multiple lines without selecting them back from the “Shapes” menu. Step 4: Select the dot from any end to resize the line or to change its direction, and you will get the output as shown below:Įxample #2 – Draw multiple lines without selecting “line shape” againĪfter the first line, if you need to create another line of the same type, you have to select the line again from the “Shapes” menu. Select the line, and you will see two dots at each end of the line as shown in below image: Step 3: In case you release the mouse cursor in between, you need not worry at all.
![hide print lines excel 2016 hide print lines excel 2016](https://spreadsheetplanet.com/wp-content/uploads/2020/07/Pagebreak-in-normal-view.jpg)
Step 2: Click anywhere in the document or the point from where you want to start, hold and drag your mouse pointer to a different location or the point where you want to end and then release.
![hide print lines excel 2016 hide print lines excel 2016](https://cdn-adclh.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/optimized/rev-ae61699/wp-content/uploads/2020/08/Faint-gray-dotted-line-in-the-worksheet.png)
Step 1: Select “Line” from the “Lines” menu.