Shift cells to the left or above

Shift cells to the left or above

To shift cells to the left or above:

  1. Select the cells to be shifted.
  2. Click Edit > Delete > Shift Cells Left or Shift Cells Up to move the cells to the left or up respectively.

    Redefine the way you work
    with Zoho Workplace

      Zoho DataPrep Personalized Demo

      If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

      Zoho CRM Training

        Create, share, and deliver

        beautiful slides from anywhere.

        Get Started Now


          Get started with Zoho Sign

          in a few quick steps!

          Download Help Guide





                       
                      Secure your business
                      communication with Zoho Mail


                      Mail on the move with
                      Zoho Mail mobile application

                        Stay on top of your schedule
                        at all times


                        Carry your calendar with you
                        Anytime, anywhere




                                Zoho Sign Resources

                                  Sign, Paperless!

                                  Sign and send business documents on the go!

                                  Get Started Now


                                      Zoho SalesIQ Resources



                                          Zoho TeamInbox Resources



                                                  Zoho DataPrep Resources



                                                    Zoho DataPrep Demo

                                                    Get a personalized demo or POC

                                                    REGISTER NOW


                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now











                                                                            • Related Articles

                                                                            • Insert cells in a sheet / Shift the cells to the right or down.

                                                                              To shift cells to the right or down: Select the cells to be shifted. Click Insert > Cell > Shift Cells Right or Shift Cells Down to move the cells to the right or down respectively.
                                                                            • LEFT

                                                                              Returns the specified number of characters from the beginning of a given text string.   Syntax   LEFT(text; [number]) text: The text that you want to get the characters from. E.g. "Zoho Sheet" number: Number of characters you want as result. Defaults ...
                                                                            • Change the alignment of data in cells

                                                                              You can change both the horizontal and the vertical alignment of data entered into the cell. To change the alignment of data inside the cells: Select the cells to be aligned.  On the default toll bar, click on Alignment icon. Choose to align left, ...
                                                                            • Remove or clear the formatting from cells

                                                                              To clear the formatting of a cell: Select the cell you want to clear the formatting of. Click on the Clear icon in the tool bar. You can then choose to clear only the formats from the cell. Alternatively, right click on the cell you want to clear the ...
                                                                            • How to merge/unmerge cells in Zoho Sheet?

                                                                              To merge cells, Select the cells you want to merge. Click on the Merge  icon on the tool bar. To unmerge/split merged cells, Select the merged cell. Click on the Unmerge icon on the tool bar.  Note: When you merge cells with content in them, please ...
                                                                            Wherever you are is as good as
                                                                            your workplace

                                                                              Resources

                                                                              Videos

                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                              eBooks

                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                              Webinars

                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                              CRM Tips

                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                Zoho Show Resources